SQL Server 2005 Service Pack 2 -- Now Available

Paul A. Mestemaker II - MSFT

SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides.

SQL Server 2005 Service Pack 2:
http://www.microsoft.com/sql/sp2.mspx

SQL Server 2005 Service Pack 2 blogs:
http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Madhu K Nair

What is new in SP2

 

http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm#BKMK_DatabaseEngine

 

list of Bugs fixed

http://support.microsoft.com/ kbid=921896

Peter Cwik

Why was the "Reports" drop down taken off the Summary Tab

Paul A. Mestemaker II - MSFT

The reports can be found by right-clicking an object in Object Explorer and then choosing the Reports fly-out.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Greg Hyzak

I read that there is a post sp-2 hotfix to apply and that the sp-2 files on MS site will be ammended for this hotfix. Any idea where to get the hotfix We've applied sp-2 and even though we are not in production yet, we will be within a month.

Paul A. Mestemaker II - MSFT

Greg Hyzak wrote:

I read that there is a post sp-2 hotfix to apply and that the sp-2 files on MS site will be ammended for this hotfix.  Any idea where to get the hotfix

For more information please visit one of the following sites:

My blog (quick summary):
http://blogs.msdn.com/sqlrem/archive/2007/03/06/Maintenance-Plan-Changes-Update.aspx

Knowledge Base Article (detail you need to be prepared):
http://support.microsoft.com/kb/933508

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Stivan

The refreshed SP2 is breaking Maintenance Plans on installations that already have plans defined:

Failed to retrieve data for this request. Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Invalid column name from_msx'. Invalid column name 'has_targets'. (Microsoft SQL Server, Error 207)

Satya SKJ

Stivan

It will be better if you can start a new thread for the problem than the original post of information post, on the other note have you applied the SP2 or try to re-design the MP.