http://www.sqlservercentral.com/Content tagged SQL Server 2005, SQL Server 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.http://www.sqlservercentral.com/scripts/Administration/63401/2008/06/08http://www.sqlservercentral.com/scripts/Administration/63401/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/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/This 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/One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem.http://www.sqlservercentral.com/articles/SQL+Server+2005/61887/2008/02/05http://www.sqlservercentral.com/articles/SQL+Server+2005/61887/Script to backup 2000/2005 databases.http://www.sqlservercentral.com/scripts/Backup/61550/2008/01/17http://www.sqlservercentral.com/scripts/Backup/61550/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/