http://www.sqlservercentral.com/Content tagged SQL Server 2000, T-SQL Aids posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Feed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Feed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/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.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/06/17http://www.sqlservercentral.com/scripts/Miscellaneous/63094/It 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/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.http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/2007/12/19http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/