SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Kenneth Igiri

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.  Read more...
By Kenneth Igiri 2015/02/03 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 2,671 reads

Check Table Size and DB Size

Two simple scripts to check table and database sizes. The scripts use temporary tables and the sp_msforeachdb/sp_msforeachtable stored procedures to present the output neatly.  Read more...
By Kenneth Igiri 2012/03/05 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,645 reads
   Items 1 to 2 of 2