SQL Server Performance Forum – Threads Archive

SQL 2005 sp2

hI gUYS Any feedback on the SP 2 ??? AKTHAR

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

would you guys recommend going sp2 on live production Server??? AKTHAR

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/

Thanks for these infos guys AKTHAR

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.

is the Db maint plan patch not part of the SP2 AKTHAR

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=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of 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.</center>

After few weeks it may be called 2b OR 2c…..[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Main reason for job security [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

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… Looks like it is one news from MVP coference <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>