All geek questions in one place

SQL Server 2005 Service Pack 3 installed, but it does not appear when you select @@

We installed Service Pack 3 for SQL Server 2005 Standard Edition (64-bit). The Add or Remove Programs menu in Microsoft SQL Server 2005 (64-bit) contains the following entries:

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

But when I run the following request on the server:

select @@version

I get this result:

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

Why doesn't it show that it works with Service Pack 3?

+3
source share
2 answers

Version 9.00.4035 uniquely identifies SP3, although it does not explicitly indicate SP3. This SP2, which you see, is for the operating system, not SQL Server. See Microsoft KB article on SQL versions.

+3
source

, Windows NT Service Pack 2. Ctrl-T, , SQL Windows .

+1

Source: https://habr.com/ru/post/1705798/

More articles:


All Articles