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

Scripts by Mitch Spruill

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

DynamicDateRangeGenerator

Generates # of dates in before/after current year. No more hardcoded date ranges.  Read more...
By Mitch Spruill 2016/08/08 | Source: SQLServerCentral.com | Category: dynamic
Rating: |  Discuss |   Briefcase | 451 reads

Date Password Last Set in AD

C# CLR routine to convert the pwdLastSet attribute to DateTime  Read more...
By Mitch Spruill 2012/10/26 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 727 reads

Dynamic Transaction Log Backup

Backup up all transaction logs based on sys.databases.  Read more...
By Mitch Spruill 2012/11/16 | Source: SQLServerCentral.com | Category: log
Rating: |  Discuss |   Briefcase | 999 reads

Dynamic Database Backup

Backup up all databases based on sys.databases.  Read more...
By Mitch Spruill 2012/11/21 | Source: SQLServerCentral.com | Category: dynamic
Rating: (not yet rated) |  Discuss |   Briefcase | 1,012 reads

MERGE Statement Generator

Generates the merge statement for a given table.  Read more...
By Mitch Spruill 2012/06/20 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 2,576 reads
   Items 1 to 5 of 5