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

The information in this article applies to:

Microsoft SQL Server 2000 (all editions)

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.

Modification Type:	Minor	Last Reviewed:	9/27/2005
Keywords:	kbHotfixServer kbQFE kbSQLServ2000sp3fix kbbug kbfix kbSQLServ2000preSP3fix KB319455