SQLServerCentral.com Scripts tagged SQL Server 2000http://www.sqlservercentral.com/Scripts tagged SQL Server 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Proc to Rename a fileA 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.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/05/13http://www.sqlservercentral.com/scripts/Miscellaneous/63094/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). http://www.sqlservercentral.com/scripts/Miscellaneous/62468/2008/05/02http://www.sqlservercentral.com/scripts/Miscellaneous/62468/Import/Export SQL Server 2000 Enterprise Manager Registered ServersExports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell. http://www.sqlservercentral.com/scripts/powershell/62275/2008/05/08http://www.sqlservercentral.com/scripts/powershell/62275/Available bytes for row expansion (adding columns) in a tableThis scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns. http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/2008/04/03http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/Generate SQL Scripts from DatabaseSimulate EM's Generate SQL Scripts with DMO and VBShttp://www.sqlservercentral.com/scripts/DMO/61811/2008/02/15http://www.sqlservercentral.com/scripts/DMO/61811/Restore database with all necessary filesIt creates the script for restoring your database with all the backups (full, differential and transaction log) needed.http://www.sqlservercentral.com/scripts/Restore/61810/2008/02/12http://www.sqlservercentral.com/scripts/Restore/61810/Backup Stored ProcScript to backup 2000/2005 databases.http://www.sqlservercentral.com/scripts/Backup/61550/2008/01/17http://www.sqlservercentral.com/scripts/Backup/61550/Check Availability Window - SQL2kThis script allows you to check the several availability windows for the current day.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61431/2008/01/18http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61431/Check Instance InfoNamed 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.http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/2007/12/19http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/