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
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
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
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
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Hi all, Got a strange one here that I hope someone can help with....
What's the best way to get better at T-SQL Querying? Something like Read/do the...
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...