http://www.sqlservercentral.com/Content tagged 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/This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/2008/07/18http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000http://www.sqlservercentral.com/scripts/Monitoring/63309/2008/07/11http://www.sqlservercentral.com/scripts/Monitoring/63309/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63172/2008/06/26http://www.sqlservercentral.com/scripts/Administration/63172/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/SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.http://www.sqlservercentral.com/articles/XML/63043/2008/06/04http://www.sqlservercentral.com/articles/XML/63043/http://www.sqlservercentral.com/questions/Lock+and+Connection+Management/62845/2008/05/16http://www.sqlservercentral.com/questions/Lock+and+Connection+Management/62845/Exports 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/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/Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.http://www.sqlservercentral.com/articles/SQL+Server+2000/62796/2008/04/17http://www.sqlservercentral.com/articles/SQL+Server+2000/62796/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/An interesting tale of David Bird's fight with tempdb.http://www.sqlservercentral.com/articles/Administration/61823/2008/03/17http://www.sqlservercentral.com/articles/Administration/61823/Simulate EM's Generate SQL Scripts with DMO and VBShttp://www.sqlservercentral.com/scripts/DMO/61811/2008/02/15http://www.sqlservercentral.com/scripts/DMO/61811/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/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/This 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/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/Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try thishttp://www.sqlservercentral.com/articles/Monitoring/61373/2007/11/19http://www.sqlservercentral.com/articles/Monitoring/61373/In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).http://www.sqlservercentral.com/articles/SQL+Server+2000/61337/2007/11/01http://www.sqlservercentral.com/articles/SQL+Server+2000/61337/Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/61296/2007/10/11http://www.sqlservercentral.com/scripts/Administration/61296/Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.http://www.sqlservercentral.com/articles/DTS/61225/2007/10/09http://www.sqlservercentral.com/articles/DTS/61225/This is one of the very useful features in SQL Server 2000 and if you ever have the need to perform this actiom, you will appreciate the knowledge in this article. http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/2005/06/15http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/