Microsoft KB Archive/319455

= FIX: Xp_msver Returns Null for Most of the Properties of a Non-English SQL Server Installation =

Article ID: 319455

Article Last Modified on 9/27/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q319455



BUG #: 356796 (SHILOH_BUGS)

BUG #: 356844 (SHILOH_BUGS)



SYMPTOMS
The xp_msver extended stored procedure may return null for most of the SQL Server properties if you run a non-localized version of Sqlservr.exe on a non-English SQL Server installation. Typically, hotfixes for Sqlservr.exe that run on a non-English installation meet this condition.

Additionally, the following error message may occur if you try to display meta data in the SQL Server Enterprise Manager:

An error occurred while trying to access the database information. The msdb database could not be opened.



CAUSE
The xp_msver extended stored procedure does not retrieve language-specific information if the language version of the Sqlservr.exe file is different from the language version of the SQL Server installation.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How To Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

Keywords: kbbug kbfix kbsqlserv2000presp3fix kbqfe kbsqlserv2000sp3fix kbhotfixserver KB319455

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.