You obtain inconsistent version information after you install SQL Server 2005 Service Pack 1 (915848)


The information in this article applies to:

  • Microsoft SQL Server 2005 Service Pack 1

SYMPTOMS

You install Microsoft SQL Server 2005 Service Pack 1 (SP1). After you do this, you use the following methods to obtain SQL Server 2005 version information.

Method 1

You run a SELECT @@VERSION Transact-SQL statement in the Query Editor of SQL Server Management Studio.

Method 2

In Control Panel, you double-click Add or Remove Programs, click Microsoft SQL Server 2005, and then click Click here for support information to open the Support Info window.

However, the methods show inconsistent version information. Method 1 shows the version number as 9.0.xxxx.xx. Method 2 shows the version number as 9.1.xxxx.xx.

Note xxxx.xx is a placeholder for the build number. The build number is the same for both methods.

MORE INFORMATION

The version number that you see in Add or Remove Programs is the version of the .msi package that installs SQL Server 2005 SP1. This version has nothing to do with the version of SQL Server 2005 SP1 that you see after you run the SELECT @@VERSION Transact-SQL statement.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:4/1/2006
Keywords:KBSQLServ2005fix kbExpertiseAdvanced kbtshoot kbprb KB915848 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.