INF: SQL Server 2000 Service Pack 2 Readme.txt Additions

Article translations Article translations
Article ID: 306909 - View products that this article applies to.
This article was previously published under Q306909
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


This article addresses several items that currently are not documented in the SP2Readme.htm file for SQL Server 2000 Service Pack 2 (SP2).


The following information has changed since publication of the SP2Readme.htm:

Version of SQL Server
To identify which version of SQL Server 2000 you have installed when you use the osql or isql utilities or the Query window in SQL Query Analyzer, at the command prompt type:


The following table shows the relationship between the version string reported by @@VERSION and the SQL Server 2000 version number.

Collapse this tableExpand this table
@@Version SQL Server Version
8.00.194SQL Server 2000 RTM
8.00.384Database Components Service Pack 1 (SP1)
8.00.534Database Components Service Pack 2 (SP2)

Microsoft has found the following issues in SQL Server 2000 SP2, which are not currently documented in the SP2Readme.htm file:
  • Sample Database FoodMart 2000 cannot connect from the Analysis Manager:
    When you run the Japanese, Chinese (Traditional), Chinese (Simplified), German or French versions of Microsoft Windows XP and matching versions of Microsoft Analysis Services Service Pack 2 (SP2), you may not be able to connect to the FoodMart 2000 sample database from the Analysis Manager. To resolve this issue, restore the database from the file.

  • Setup fails when started from Terminal Server Client on localized versions of SQL Server SP2.
    When you attempt to install a localized version of SQL Server SP2 through Terminal Server, the setup process fails. Microsoft is currently researching this issue and will post additional information when available.


Article ID: 306909 - Last Review: October 24, 2013 - Revision: 3.2
  • Microsoft SQL Server 2000 Service Pack 2
kbnosurvey kbarchive kbinfo KB306909

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from