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

Scripts by Theo Ekelmans profile

   Items 1 to 6 of 6   

Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file. It's tested for SQL 2005, 2008(R2), 2012 and 2014. Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.  Read more...
By Theo Ekelmans 2016/04/21 | Source: | Category: restore headeronly
Rating: (not yet rated) |  Discuss |   Briefcase | 294 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's 
By Theo Ekelmans 2015/05/13 | Source: | Category: automatic
Rating: |  Discuss |   Briefcase | 2,586 reads

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level  Read more...
By Theo Ekelmans 2015/09/17 | Source: | Category: job
Rating: |  Discuss |   Briefcase | 4,873 reads

Compare 2 datasets and output delta in one TSQL statement

There are many ways 2 compare datasets to find differences, this is one of them.  Read more...
By Theo Ekelmans 2011/11/04 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,160 reads
   Items 1 to 6 of 6