Microsoft KB Archive/915848

= You obtain inconsistent version information after you install SQL Server 2005 Service Pack 1 =

Article ID: 915848

Article Last Modified on 4/1/2006

-

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. . Method 2 shows the version number as 9.1. .

Note  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 &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsqlserv2005fix KB915848

-

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

© Microsoft Corporation. All rights reserved.