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

Scripts by Jon Morisi

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Last Backup Taken, or Not

Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.  Read more...
By Jon Morisi 2012/05/24 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,413 reads

View Errors in the Default Trace

Returns records with errors from the default trace ordered by most recent first  Read more...
By Jon Morisi 2009/11/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 648 reads

SQL 2000 datafile locations

This script pulls all data and log files associated with user db's   Read more...
By Jon Morisi 2009/09/08 | Source: SQLServerCentral.com | Category: sql server 2000
Rating: |  Discuss |   Briefcase | 418 reads

Index Fragmentation for All Databases

Returns Top 25 fragmented indexes complete with full object name and index name.  Read more...
By Jon Morisi 2011/04/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,373 reads
   Items 1 to 4 of 4