@@Version still shows Service Pack 1

We just installed the service pack 2 to our server, so I did a select @.@.version but it's still say Service Pack 1, even though the version number is now 3054. Is that a bug in the service pack?

Thanks.

Can you post the entire string returned by SELECT @.@.VERSION? My guess is that you are seeing the Windows OS Service Pack that is also included in the @.@.VERSION call. SQL Server should return SP2.

Thanks,

Sam Lester (MSFT)

|||Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
|||

Yeah, the SP1 in this case refers to your Windows Version:

Windows NT 5.2 (Build 3790: Service Pack 1)

The Service Pack level apparently isn't listed in the @.@.VERSION as I thought it was. Build 3054 is definitely SP2, but you can also check Add/Remove Programs report or the setup regitry hives to confirm.

Thanks,
Sam Lester (MSFT)

|||
Thanks for your help.