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

avatar image

770 36 41 45

(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

avatar image

10.8k 37 58 51

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

avatar image

12.1k 30 36 42

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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Nov 21, 2012 at 04:40 PM

Seen: 627 times

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

Copyright 2018 Redgate Software. Privacy Policy