Download Microsoft SQL Server 2008 R2 SP2

Microsoft has released service pack 2 for SQL Server 2008 R2. Downloads are available for 32bit, 64bit and ia64 environments, and are between 100MB and 1GB in size. The service pack contains all the improvements from updates 1 to 5 and of course a large number bug fixes† The release notes for this update can be found below.

SQL Server 2008 R2 SP2 Now Available

As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2. Service Pack 2 for SQL Server 2008 R2 includes product improvements based on requests from the SQL Server community and hotfix solutions provided in SQL Server 2008 R2 SP1 Cumulative Updates 1 to 5. A few highlights are as follows:

• Reporting Services Charts Maybe Zoomed & Cropped
  Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped. To work around the issue some customers set ImageConsolidation to false.
• Batch Containing Alter Table not Cached
  In certain situations with batch files containing the alter table command, the entire batch file is not cached.
• Collapsing Cells or Rows, If Hidden Render Incorrectly
  Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed. When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.

Customers are highly encouraged to stay on a supported service pack to ensure they are on the latest and most secure version of SQL Server 2008 R2.