SQL2005 SP4 is here

Question

SQL2005 SP4 is here

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

ALZDBA (12/21/2010)
The issue with the maintenance plan is that it is actually an SSIS package at SQLServer side, to you'll have to use the 2005 for sql2005.

SSMS 2008 actually modifies and saves the maintenance plan... and (surprisingly) it works. However, if you open it up again in SSMS 2005, you'll get an error about an invalid property. Just click OK to resolve the error, and when you save the MP it will be saved back in 2005 format.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

SQLkiwi (12/21/2010)
There's not much new at all in SP4, compared to the previously released cumulative updates for SP3.
Are people excited about this primarily because Service Packs are perceived as being better tested than cumulative updates, and so more acceptable to the powers-that-be?

Depending on your environment, downtime is a big deal, as is testing. Service Packs give you a nice place to apply a set of changes, that has been tested. The CUs, while they are tested, are not recommended, even by MS, to be applied without experiencing specific issues. The problem is that if you have an issue and apply CU9, you are applying CUs 1, 2, 3, etc., which you might not be aware of the changes. An SP gives you a better baseline on which to test, research, and schedule a patch.

I don't expect anything new in this, but I expect one a year that give us a baseline on which to base future actions.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

And this is soon:

Here is Cumulative update 1: support.microsoft.com/kb/2464079

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 4

ALZDBA (12/26/2010)
And this is soon:
Here is Cumulative update 1: support.microsoft.com/kb/2464079

Heh... and now we know why I don't install SP's just as soon as they come out. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 5

Indeed, you'll have to test it anyway 😀

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 6

I understand why there's a CU since the time it takes to assemble and test the SP means that another CU was assembled in the meantime and couldn't get added. That's a good process since you can't alter the package in testing to add other patches in there.

However I was hoping that we'd get a final SP to close out 2005. Makes me want to push for an SP5 at some point, but I am sure that will never happen.

GSquared SSC Guru Points: 260824 More actions · Answer 7

Steve Jones - SSC Editor (12/18/2010)
I knew this was coming, and it's great news that it's out.
Downloading myself now.

Okay, I'll bite. When did you upload yourself? 😀

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 8

Steve Jones - SSC Editor (12/27/2010)
I understand why there's a CU since the time it takes to assemble and test the SP means that another CU was assembled in the meantime and couldn't get added. That's a good process since you can't alter the package in testing to add other patches in there.
However I was hoping that we'd get a final SP to close out 2005. Makes me want to push for an SP5 at some point, but I am sure that will never happen.

I was hoping for the same thing. I was hoping they'd spend the time to do a final SP so it included all outstanding issues. Dunno... maybe a new issue popped up.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 9

ALZDBA (12/21/2010)
WayneS (12/21/2010)
ALZDBA (12/20/2010)
Apparently, on a side by side client install it breaks SQL2008 SSMS project stuff.
- New project on a new folder generates "creating project failed"
- opening an existing sql2008 project generates "the located assembly's manifest definition does not match the assembly reference. (exception from HRESULT: 0x81131040)"
I'm still trying to figure out what's going on and how to fix it, but just wanted to let you know.
On my laptop with SSMS 2005 and 2008 installed, I used to get this message all the time. To fix it for 2008, I needed to uninstall SSMS for 2008, and reinstall them. Which then broke it for 2005, so you'd have to do the reverse to fix it for 2005. What I finally did to "permanently" "solve" this was to completely uninstall the SSMS for both versions, then install SSMS 2008. I just needed to be careful of working with maintenance plans on 2005 servers - SSMS has something different (don't remember right now) that would cause them to be invalid if saved - but SSMS 2005 would fix it when opening it up.
Thank you for the feedback.
Today I've downloaded CU5 for SQL2008R2. I'll first test if that fixes the issue, but if it doesn't, I'll have to fall back to the solution you mentioned.
The issue with the maintenance plan is that it is actually an SSIS package at SQLServer side, to you'll have to use the 2005 for sql2005.

Applying CU5 for SQL2008R2 fixed my issue on the SSMS solutions :w00t:

I'll have to do more testing after I get back at the office.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me