December 21, 2010 at 8:25 pm
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
December 25, 2010 at 2:27 pm
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.
December 26, 2010 at 12:11 am
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
December 26, 2010 at 8:50 am
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
Change is inevitable... Change for the better is not.
December 26, 2010 at 10:27 am
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
December 27, 2010 at 10:14 am
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.
December 27, 2010 at 10:22 am
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
December 27, 2010 at 5:45 pm
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
Change is inevitable... Change for the better is not.
January 4, 2011 at 2:46 am
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
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply