Following is part 1 of a list of fixes and other various improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the article numbers below to view the articles in the Microsoft Knowledge Base:
INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (2 of 2)
INFO: List of Bugs Fixed in MDAC 2.6 Service Pack 1
To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:
The result of this query is:
8.00.194 if SQL Server 2000 with no service pack applied
8.00.384 if SQL Server 2000 Service Pack 1
Please note that the workarounds described in these articles are provided for information only. You do not need to implement these workarounds if you have the updated software.
For more information about each corrected problem in Service Pack 1 for Microsoft SQL Server 2000 (build 8.00.384), either click the link or use the Qxxxxxx
number to query for the article in the Microsoft Knowledge Base.
To view the Service Pack 1 Readme.txt file that accompanies the Service Pack 1, see the following article in the Microsoft Knowledge Base:
300516 For additional information on obtaining SQL Server 2000 Service Pack 1, click the article number below to view the article in the Microsoft Knowledge Base:
INF: Readme.txt File for SQL Server 2000 Service Pack 1
INF: How to Obtain the Latest SQL Server 2000 Service Pack