sqlserver service pack for service pack 2

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 service pack for service pack 2

Author

Topic

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-16 : 10:57:24

yestarday there is an article released about the service pack for the service pack 2 for sqlserver wo downloaded before mar 5 , 2007.

but to my development server i didn't download sp2 yet. Ifs it safe to download the sp2 for sqlserver 2005 enterprise edition now??

thanks,

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-16 : 10:58:50

If it is safe to download? Yes.
Safe to install? mmmm..Yes.

Peter Larsson
Helsingborg, Sweden

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-16 : 11:13:57

is there any link for the latest sp2 after the fixes on march 5, 2007

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-16 : 11:17:21

Goto www.microsoft.com/sql
Latest version is 9.00.3050.00

Peter Larsson
Helsingborg, Sweden

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-16 : 16:28:48

Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

My server reports the above result when i executed select @@version after applying the service pack 2.

Is this right??

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-16 : 16:43:18

No.
The newest service pack 2 is 9.00.3050.00

Peter Larsson
Helsingborg, Sweden

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-17 : 01:56:50

I think build is 3152...
http://support.microsoft.com/kb/933097

MohammedU

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-17 : 02:45:11

Great spotted!

Peter Larsson
Helsingborg, Sweden

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-03-17 : 02:52:35

the builds are pretty confusing right now.

read this article for explanation http://support.microsoft.com/?kbid=933508 . build 3050 is the latest SP2 release right now. The link that MohammedU posted is for a cumulative hotfix rollup that can be applied on top of that.

-ec

EDIT:
fixed link (removed dot at end)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-17 : 02:54:53

Wonder if apply the hotfix to build 3050 is it same as applying the SP2 build 3152 ?

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-03-19 : 10:24:12

http://support.microsoft.com/?kbid=933508.
The above link is invalid. can anybody helpme out in this??

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-03-19 : 12:12:38

quote:
Originally posted by priyaram

http://support.microsoft.com/?kbid=933508.
The above link is invalid. can anybody helpme out in this??

http://support.microsoft.com/kb/933508/en-us

priyaram
Yak Posting Veteran

82 Posts

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

does any body have any idea why after the installation of the sp2 , my version still shows sp1.
i am really confused

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-03-19 : 15:16:11

quote:
Originally posted by priyaram

does any body have any idea why after the installation of the sp2 , my version still shows sp1.
i am really confused

Did the install say the Service pack installed without error?

-ec

Kristen
Test

22859 Posts

Posted - 2007-03-19 : 16:07:34

"my version still shows sp1"

Is that perhaps SP1 for Windows (rather than the SPn for SQL?)

I think the way that is shown is crap, to be honest.

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources