This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".  Read more...

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

An interesting tale of David Bird's fight with tempdb.  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...

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