Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20187 Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
So for I don't see any issues... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19624 MohammedU. Moderator SQL-Server-Performance.com
Yes. It'll be fine. the only issue I have found so far is that subqueries are no longer allowed in Output clauses - this broke one SP in one of our applications. This was caught in testing fortuantely. This change is very well hidden in the SP2 books online update at the very bottom of the OUTPUT topic. It's obscure though and unlikely to affect many people I wouldn't have thought.
No issues... but if downloaded SP2 before 5th March don't use it... Down load again to get the hotfix included SP2... MohammedU. Moderator SQL-Server-Performance.com
Some of our guys experiencing issues in report service after installing SP2. but not yet conformed by MS ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
If you are using database maintenance plans on the SQL server where SP2 is applied or thinking to apply then ensure to apply the patch for DB maint.plans too. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
SP2 - Check Database Task on Maint only ever does master http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
No after the SP2 release MS has released this patch (which is an unofficial SP2a). Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I believe it is included in SP2, If you download SP2 after 3/5/2007... The maintenance plan pathc was related to backup retention issue but the following might be after sp2 patch... SP2 - Check Database Task on Maint only ever does master http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Just now I got an email from Tony Rogerson (SQL User Group) cofirming that the following one post patch bug... SP2 - Check Database Task on Maint only ever does master http://sqlblogcasts.com/blogs/tonyr...base-task-on-maint-only-ever-does-master.aspx We have recently seen the release of SP2 and SP2a for SQL Server 2005. SP2a was released due to a bug in maintenance plans You can read the details of the bug here Maintenance Plan Changes in SQL Server 2005 SP2 the re-released service pack here SQL Server 2005 Service Pack 2 Rereleased as well as details of an outstanding bug (I mean one thats not fixed rather than a really good one) here SP2 - Check Database Task on Maint only ever does master. If you want to understand this more then I suggest you come to the usergroup meeting in April. MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Thats why in MS community it is called unofficial SP2a [<img src='/community/emoticons/emotion-1.gif' alt='' />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
After few weeks it may be called 2b OR 2c.....[<img src='/community/emoticons/emotion-2.gif' alt='' />] <br />Main reason for job security [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS†with no warranties for accuracy.<br />
May be or may not be, they are preparing for SP3 CTP and might be middle of this year. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Good to know...<br />Looks like it is one news from MVP coference <img src='/community/emoticons/emotion-1.gif' alt='' /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS†with no warranties for accuracy.<br />
