sqlserver 2005 SP2 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sqlserver 2005 SP2

Author

Topic

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-07 : 16:38:22

is it safe now to install service pack 2 for the new test server which is having sqlserver 2005 and sp1

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-07 : 16:40:23

I've installed it on all of our development servers.

Tara Kizer

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-07 : 19:00:26

The "new" SP2 has version number 9.00.3050.00.
Quite a step from "old" SP2 version number 9.00.3042.00

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-07 : 21:14:32

quote:
Originally posted by Peso

The "new" SP2 has version number 9.00.3050.00.
Quite a step from "old" SP2 version number 9.00.3042.00

Peter Larsson
Helsingborg, Sweden

Where did you get the 3050 ? I just download and install SP2 and it is 3042

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-07 : 21:19:04

Found the hot fix. http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-08 : 01:02:36

http://weblogs.sqlteam.com/tarad/archive/2007/03/07/60127.aspx

Tara Kizer

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-08 : 01:07:31

Actually i downloaded and install from here

@@version still gives me 9.00.3042 and even that link state the version as 9.00.3042.

So kind of confusing weather i have installed the SP2 with or without the hotfix.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-08 : 01:12:50

I was misinformed then. I will update my weblog.

Tara Kizer

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-08 : 01:20:45

quote:
Originally posted by tkizer

I was misinformed then. I will update my weblog.

Tara Kizer

You might be correct in the first place. See http://support.microsoft.com/kb/933508

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-08 : 01:24:43

Maybe MS did not updated ths SP2 but did not change the version no ?

quote:


Quick Details
Version                     :	9.00.3042
Knowledge Base (KB) Articles:	KB921896
Date Published              :	3/6/2007

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-08 : 01:33:46

I went to MicrosoftUpdate and found it there.

SELECT @@VERSION

9.00.3050.00

Peter Larsson
Helsingborg, Sweden

Kristen
Test

22859 Posts

Posted - 2007-03-08 : 03:46:25

Is it just me, or has the release of SP2 been a bit of a muddle?

Kristen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-08 : 12:41:19

quote:
Originally posted by Kristen

Is it just me, or has the release of SP2 been a bit of a muddle?

Kristen

What do you mean?

Tara Kizer

Kristen
Test

22859 Posts

Posted - 2007-03-08 : 13:05:56

It seemed that there have been 3 releases, fixing some things - or was that jsut whilst it was in public Beta?

Kristen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-08 : 13:27:12

Since it was officially released, there has been only one update.

I stay away from Betas except for major releases, such as Yukon.

Tara Kizer

Kristen
Test

22859 Posts

Posted - 2007-03-09 : 04:37:33

"there has been only one update"

IMO it should have been called SP2a to lessen the confusion

Kristen

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-09 : 12:11:49

Agreed.

Tara Kizer

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2007-03-20 : 13:15:24

quote:
Originally posted by tkizer

I've installed it on all of our development servers.

Tara Kizer

Does that mean you have installed SP1 on your Production server?
I've not applied SP1 or SP2 to Dev/Test/Live yet. Is it time? Any major benefits?
Or shall I not fix what isn't broken?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-03-20 : 13:44:11

We didn't upgrade any databases to 2005 until service pack 1 was released. Typically the RTM version has a lot of bugs that need to be worked out, so a lot of people wait for the first service pack.

So yes we have sp1 installed in production.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

JimVWilliams
Starting Member

7 Posts

Posted - 2007-04-02 : 18:10:52

This wasn't a beta, it was an improperly tested full release. If you read the details here:
http://blogs.sqlserverclub.com/?p=19
, you'll see it's pretty unforgiveable what MS have dropped into our laps.
Same advice as always - never install until it's been out six months.
Jim.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources