SQL Server 2008 R2 Service Pack 2 Customer Technology Preview Available

Dear Customers,

Microsoft and the SQL Server Sustained Engineering team are pleased to announce the availability of SQL Server 2008 R2 Service Pack 2 CTP. 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. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center.

Below are a few key customer requested updates in Microsoft SQL Server 2008 R2 SP2 CTP:

• 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.

SQL Server 2008 R2 SP2 provides software solutions for these customer reported issues and more.  For more details please visit the KB article 2630455 accompanying the SQL Server 2008 R2 SP2 CTP release.

To download the SQL Server 2008 R2 SP2 release please select from the links below:

• SQL Server 2008 R2 SP2 CTP
• SQL Server 2008 R2 SP2 Express CTP
• SQL Server 2008 R2 SP2 Feature Pack CTP

Thanks to all customers your continued support and feedback.

Abhishek Sinha
Program Manager
SQL Server Sustained Engineering

Related Links:

• SQL Server 2008 R2 SP2 CTP
• SQL Server 2008 R2 SP2 Express CTP
• SQL Server 2008 R2 SP2 Feature Pack CTP