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...

Read more...

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...

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...

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.  Read more...

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...

An interesting tale of David Bird's fight with tempdb.  Read more...

Simulate EM's Generate SQL Scripts with DMO and VBS  Read more...

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...

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.  Read more...

This script allows you to check the several availability windows for the current day.  Read more...

Script to backup 2000/2005 databases.  Read more...

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...

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...

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).  Read more...

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.  Read more...

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.   Read more...

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...

Script to backup 2000/2005 databases.  Read more...

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.  Read more...