安裝時系統會進行檢查，確認您已有裝的SQL Server的功能與版本。
針對客戶不斷的需求提出，本修正也作了下列的更新與異動：
- 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.
主要修正問題：
| VSTS bug number | KB article number | Description |
|---|---|---|
| 820875 | 922578 | FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 |
| 728527 | 2216456 | SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services |
| 820858 | 2550375 | FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server |
| 820878 | 2565683 | FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment |
| 820756 | 2588050 | FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed |
| 901689 | 2653857 | FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version |
| 873603 | 2682488 | FIX: Backup operation fails in a SQL Server 2008, in a SQL Server 2008 R2 or in a SQL Server 2012 database after you enable change tracking |
| 958983 | 2719217 | FIX: Latch time-out error when you have heap tables and when data compression is enabled in SQL Server 2008 R2 or in SQL Server 2012 |
檔案下載：
Microsoft® SQL Server® 2008 R2 Service Pack 2
http://www.microsoft.com/en-us/download/details.aspx?id=30437
參考連結：
SQL Server 2008 R2 SP2 Is Now Available! http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/07/26/sql-server-2008-r2-sp2-is-now-available.aspx
關鍵字：SQL Server、Service Pack、SQL Server 2008R2
沒有留言:
張貼留言