x

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?
more ▼

asked Nov 21, 2012 at 04:40 PM in Default

Troy_2012 gravatar image

Troy_2012
750 26 37 39

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
can you try SELECT SERVERPROPERTY('ProductLevel')
more ▼

answered Nov 21, 2012 at 05:11 PM

Cyborg gravatar image

Cyborg
10.6k 36 40 45

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, 2012 at 06:18 PM Troy_2012
You don't have an SP... its at the Released To Manufacturing version.
Nov 21, 2012 at 06:28 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Nov 21, 2012 at 06:09 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

This catches out so many people....must admit I've been one of them in the past
Nov 21, 2012 at 06:54 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x738

asked: Nov 21, 2012 at 04:40 PM

Seen: 501 times

Last Updated: Nov 23, 2012 at 01:44 AM