Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by David Kranes

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Get Database info

This SQL script will return basic information on each database on your server.  Read more...
By David Kranes 2014/01/21 | Source: SQLServerCentral.com | Category: database information
Rating: |  Discuss |   Briefcase | 1,746 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2014/01/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 800 reads

Determine when a Stored Procedure was created and last altered

Determine when a Stored Procedure was created and last altered.  Read more...
By David Kranes 2014/01/15 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,800 reads

Modified SP_WHOM

Provides sp_who data plus a connection summary and lead blocker details.  Read more...
By David Kranes 2014/01/23 | Source: SQLServerCentral.com | Category: sp_whom
Rating: |  Discuss |   Briefcase | 1,889 reads

Generate Trigger DDL

Dynamically generate trigger DDL and write to individual SQL files.  Read more...
By David Kranes 2013/12/02 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 1,343 reads

View Active Session SQL

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...
By David Kranes 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,044 reads
   Items 1 to 6 of 6