I installed SQLServer 2005SP4-KB2463332-x86-ENU on SQL Server2005 Enterprise Edition,windows server 2008 Enterprise.
When I run the tsql select @@version I found Service Pack 1 I tried with Developer edition and Win7 and the result is same...Is that correct?
can you try SELECT SERVERPROPERTY('ProductLevel')
answered Nov 21, 2012 at 05:11 PM
I'm going to assume you're reading the Windows SP version and believing it SQL Server's.
Here's an example @@VERSION:
The part in bold is the O/S... the 9.00.4060.00 part is SQL Server SP3.
Use SELECT SERVERPROPERTY('ProductLevel') as suggested.
answered Nov 21, 2012 at 06:09 PM