List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
31,930 reads
Shiva
Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
1,951 reads
Create Role for specific set of Objects based on a set of Conditions.
This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
2008-10-08 (first published: 2008-07-23)
1,118 reads
Blogs
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
Power BI: Making Date & Time Keys
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Forums
Date format - being overridden?
Hi all, Got a strange one here that I hope someone can help with....
Best way to understand Querying much better
What's the best way to get better at T-SQL Querying? Something like Read/do the...
Intermittent "nesting level exceeded" error
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
Ask SSC