Installed Service Pack 3 for SQL Server 2005 but it does not show up when selecting @@version

Posted by Blegger on Stack Overflow See other posts from Stack Overflow or by Blegger
Published on 2009-04-02T14:56:33Z Indexed on 2010/06/01 23:03 UTC
Read the original article Hit count: 102

Filed under:
|

We installed Service Pack 3 for SQL Server 2005 Standard Edition (64-bit). In the Add or Remove Programs menu we have the following entries under Microsoft SQL Server 2005 (64-bit):

  • Service Pack 3 for SQL Server Integration Services 64-bit) ENU (KB955706)
  • Service Pack 3 for SQL Server Notification Services 2005 (64-bit) ENU (KB955706)
  • Service Pack 3 for SQL Server Database Services 2005 (64-bit) ENU (KB955706)
  • Service Pack 3 for SQL Server Tools and Workstation Components 2005 (64-bit) ENU (KB955706)

But when I run the following query on the server:

select @@version

I get this result:

Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Why does it not display that it is running Service Pack 3?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2005