Discrepancy in whether SP2 is installed

I couldn't remember which computers I had already installed sp2 on so checked but one computer (running Windows Server 2003 and SQL 2005 Enterprise Edition) seems to have a discrepancy. SELECT @.@.VERSION returns (Build 3790: Service Pack 1) but the status bar shows "9.0 SP2". Thanks for any insight into this.

-Dave

Can you post the entire string for the @.@.version call? This output includes the OS service pack as well as the SQL Service pack, so my guess is that the SP1 refers to your OS SP.

Thanks,
Sam Lester (MSFT)

|||

Here it is:

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

Mar 23 2007 16:28:52

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

(1 row(s) affected)

Thanks,

-Dave

|||

Yes, the first line in the @.@.VERSION call shows that you have SP2 installed.

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

This line shows your SQL version (3054). SP2 is build number 3042, which means you've applied SP2 and a patch on top of that (cumulative patch 3054).

The OS edition is stated in the last line:

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I believe that means you are running Windows 2003 SP1.

Thanks,
Sam