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

Scripts with tag SQL Server 2000 Rss

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

SQL Server 2005 (5)     Miscellaneous (2)     Enterprise Manager (1)     Registered Servers (1)    
T-SQL Aids (3)     Administration (1)     Maintenance and Management (1)     Restore (1)    
Backup (2)     DMO (1)     powershell (1)     T-SQL (1)    

Search for any content tagged SQL Server 2000

Add a script

   Items 1 to 9 of 9   
 

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 | 18 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 1,263 reads

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...
By Chad Miller 2008/05/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |  Briefcase | 601 reads

Available bytes for row expansion (adding columns) in a table

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...
By ruchir 2008/04/03 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 339 reads

Generate SQL Scripts from Database

Simulate EM's Generate SQL Scripts with DMO and VBS  Read more...
By Absinthe 2008/02/15 | Source: SQLServerCentral.com | Category: DMO
Rating: (not yet rated) |  Discuss |  Briefcase | 1,192 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 | 883 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2008/01/17 | Source: SQLServerCentral.com | Category: Backup
Rating: |  Discuss |  Briefcase | 2,506 reads

Check Availability Window - SQL2k

This script allows you to check the several availability windows for the current day.  Read more...
By Pedro Lopes 2008/01/18 | Source: SQLServerCentral.com | Category: Maintenance and Management
Rating: |  Discuss |  Briefcase | 582 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 | 917 reads
   Items 1 to 9 of 9