The SQL Server 2008 R2 Service Pack 2 CTP released to download center 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.
"Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2 CTP," Micorosoft stated.
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.
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.
Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center: