Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Greg Drake

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2015/10/30 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 3,251 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,815 reads

sp_spaceused rewritten as one query (no cursors)

Query that simulates running sp_spaceused on every applicable object in a database and gathering it all into a single result set.  Read more...
By Greg Drake 2016/05/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,038 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,023 reads
   Items 1 to 4 of 4