Save yourself a headache when you're working with SQL Server 2000 Service Pack 2 (SP2)—read the addendum to the readme.txt file. The original readme.txt file incorrectly states that the value of @@version for SQL Server 2000 SP2 is 8.00.532. The...
From time to time, I run across undocumented Query Analyzer features. Microsoft software designer Gert Drapers—primary designer of all the SQL Server 2000 tools, including Query Analyzer—recently showed me an undocumented way to generate a list of...