Problem SP4 with SQLServer2005

Dear All,

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?

asked Nov 21 '12 at 04:40 PM in Default

Troy_2012
600 ● 2 ● 11 ● 19

(comments are locked)

2 answers:

can you try SELECT SERVERPROPERTY('ProductLevel')

answered Nov 21 '12 at 05:11 PM

Cyborg
10.2k ● 31 ● 39 ● 44

OK I run SELECT SERVERPROPERTY('ProductLevel') on my laptop and show me RTM My laptop have SQLServer 2008,Win7 . How I now which service pack I used with this machine

Nov 21 '12 at 06:18 PM Troy_2012

You don't have an SP... its at the Released To Manufacturing version.

Nov 21 '12 at 06:28 PM Blackhawk-17

(comments are locked)

I'm going to assume you're reading the Windows SP version and believing it SQL Server's.

Here's an example @@VERSION:
Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Mar 17 2011 13:20:38 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

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 '12 at 06:09 PM