SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags SQL Server 2000, T-SQL Aids Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (2)     Restore (1)    
Backup (1)     T-SQL (1)    
Miscellaneous (1)    
   Items 1 to 3 of 3   
 

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2008/06/17 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 997 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2008/02/12 | Source: SQLServerCentral.com | Category: Restore
Rating: |  Discuss |  Briefcase | 1,107 reads

Check Instance Info

Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.  Read more...
By Pedro Lopes 2007/12/19 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: |  Discuss |  Briefcase | 1,192 reads
   Items 1 to 3 of 3