Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,931 reads
Delete Duplicates using CTE
Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).
2007-08-23
1,098 reads
Blogs
Summit Launch Pricing Ends June 7
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Forums
Not wanting to use a Cursor, but...
Ok, need someone to talk me off the cursor ledge on this one. I...
Better Communication Through Less Messaging
Comments posted to this topic are about the item Better Communication Through Less Messaging
MuleSoft Integration with Azure Key Vault
Comments posted to this topic are about the item MuleSoft Integration with Azure Key...
Ask SSC