Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,603 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,099 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 2013/06/27 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,303 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 | 912 reads
   Items 1 to 4 of 4