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)
29,405 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,950 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,114 reads
Blogs
Daily Coping 8 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Don’t be afraid of No
How many times have you been afraid to hear “No”? We have all been...
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Forums
How to do a Matrix properly
Hi everyone I have some events data with related delegates. The events have two...
DBCC CHECKDB output
I ran a DBCC on a database and it found some anomalies. Just looking...
Why is sys.master_files showing the size of RBS files as 0?
Dear Everyone I hope you are all safe in these strange times. I am...
Ask SSC