SQL Server 2005 Service Pack 2 is also Released!!

  • Article

I am always amazed at how fast Rodney is able to get a post up about a topic!!  He reminds me of Hammy the squirrel from one of my kids' favourite movies - Over the Hedge.  I think Virtual PC 2007 was out and released for about 17 seconds before Rodney blogged about it!!

For those of you working with SQL Server 2005, you will be glad to know that Service Pack 2 of SQL Server 2005 is officialy released.  It was released yesterday so I apologize for the delay, but we can't all be Hammy -  I mean Rodney .  

SQL Server 2005 Service Pack 2 includes a number of performance enhancements, as well as fixes to the product, and some new features like:

  • Support for Microsoft Office 2007 in SQL Server 2005 Analysis Services
  • Multi-server support for Maintenance Plans
  • Support for Common Criteria compliance  through logon triggers
  • SharePoint integration for SQL Server Reporting Services
  • Ability to integrate custom reports into SQL Server Management Studio

To see what's new in SQL Server 2005 Service Pack 2 go to https://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm. 

To download SQL Server 2005 Service Pack 2 go to https://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en.  To download SP2 for SQL Server 2005 Express Edition go to https://www.microsoft.com/downloads/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&displaylang=en or https://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en for SQL Server 2005 Express Edition with Advanced Services.

Damir