[EN] SQL Server 2008 Service Pack 1 Cumulative Update 10 is available

LOGO__SQLServer2008R2Sp1Xmass gift from Microsoft for DBA this year has been delivered in three parts. Second part is for SQL Server 2008 R2 with Service Pack 1.

In this Cumulative Update 10 [version build: 10.50.2868.0] Microsoft resolved a lot of requested issues which can be applies to:

  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise

Here is the list of fixed bugs:

VSTS BUG: 1131075 | 819546
FIX: SQL Server support for mounted volumes

VSTS BUG: 1111503 | 972936
FIX: Error message when you run a query in SQL Server 2008 or in SQL Server 2005: "SqlDumpExceptionHandler: Process generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."

VSTS BUG: 1133942 |2509302
FIX: A database transaction log continues to grow after you upgrade to SQL Server 2008 SP2 or SQL Server 2008 SP3

VSTS BUG: 898887 | 2651629
FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1133921 | 2696161
FIX: Error message when you try to view a report in SSRS 2008 R2 or in SSRS 2008: "Different query parameters resulted in a same hash"

VSTS BUG: 1061515 | 2715512
FIX: Error messages when you use dtexec to execute packages in SQL Server 2008 Integration Services

VSTS BUG: 989285 | 2734191
FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2

VSTS BUG: 1133926 | 2756471
FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008

VSTS BUG: 1057934 | 2761400
FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2

VSTS BUG: 1133938 | 2761934
FIX: Support for the varchar(max), nvarchar(max), and varbinary(max) data types is added in most OLE DB providers in SQL Server 2008

VSTS BUG: 1133946 | 2770837
FIX: "Windows NT user or group ‘Domain_name\User_name’ not found" error message when you add a login to a case-sensitive SQL Server 2008 instance

VSTS BUG: 1133934 | 2770891
FIX: "Non-yielding Scheduler" error message when you insert a record that contains large object (LOB) data into a snapshot database in SQL Server 2008

VSTS BUG: 1094546 | 2777963
FIX: Installation fails when you try to install a cumulative update to an instance of SQL Server 2008 R2

VSTS BUG: 1133950 | 2778088
FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008

VSTS BUG: 1124025 | 2781486
FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2

VSTS BUG: 1136682 | 2786212
FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 10

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for 32-bit, 64-bit and Itanium). This release is prepared as multilingual package.