Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

Cumulative Update package 11 for SQL Server 2008 R2 is available for download - SQL Server Knowledge Sharing Network (@sqlmaster)

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

The latest instalment of Cumulative Update package for SQL Server 2008 R2 is available for download, before implement it on production make sure you test the installation.

Build 10.50.1809.0 (cumulative update) and the parent build of this build is 10.50.1807.0.

The list of issues are as follows with their KBA:

VSTS bug number

KB article number Description

834627

955850   (http://support.microsoft.com/kb/955850/ )

Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL 'SqlServerSpatial.dll': This application has failed to start because the application configuration is incorrect"

765506

970198   (http://support.microsoft.com/kb/970198/ )

FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008 or in SQL Server 2008 R2

826729

2445812   (http://support.microsoft.com/kb/2445812/ )

FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008 or in SQL Server 2008 R2

799307

2515286   (http://support.microsoft.com/kb/2515286/ )

FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

799295

2583994   (http://support.microsoft.com/kb/2583994/ )

FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops

799324

2588970   (http://support.microsoft.com/kb/2588970/ )

FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times

776490

2590839   (http://support.microsoft.com/kb/2590839/ )

FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2

799292

2591461   (http://support.microsoft.com/kb/2591461/ )

FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2

799304

2598903   (http://support.microsoft.com/kb/2598903/ )

FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

831275

2603910   (http://support.microsoft.com/kb/2603910/ )

FIX: Backup fails in SQL Server 2008 or in SQL Server 2008 R2 if you enable change tracking on the database

847239

2616481   (http://support.microsoft.com/kb/2616481/ )

FIX: SSRS 2008 R2 report has no Export menu in Internet Explorer 9.0 if you use the out-of-box viewer page in the SharePoint Report Viewer Web Part

834620

2618676   (http://support.microsoft.com/kb/2618676/ )

FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

834617

2618680   (http://support.microsoft.com/kb/2618680/ )

FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver

766723

2624915   (http://support.microsoft.com/kb/2624915/ )

FIX: Part of a report is not displayed when you use the Report Viewer Web Part on a SharePoint 2010 site to view a SSRS 2008 R2 report

834636

2628126   (http://support.microsoft.com/kb/2628126/ )

FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column

831257

2629456   (http://support.microsoft.com/kb/2629456/ )

FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2

822377

2634571   (http://support.microsoft.com/kb/2634571/ )

FIX: Slow performance when you run the CHECKDB WITH PHYSICAL_ONLY command on a large database in SQL Server 2008 R2

824538

2636425   (http://support.microsoft.com/kb/2636425/ )

FIX: Incorrect result when you concurrently update multiple Excel 2010 sheets that use PowerPivot for Excel 2010 in SQL Server 2008 R2

834639

2638448   (http://support.microsoft.com/kb/2638448/ )

FIX: Access violation when a query is compiled or recompiled in SQL Server 2008 or in SQL Server 2008 R2

836361

2644260   (http://support.microsoft.com/kb/2644260/ )

FIX: A main report is re-rendered when you click a link to view a drillthrough report in SSRS 2008 R2

846406

2649359   (http://support.microsoft.com/kb/2649359/ )

FIX: An access violation occurs in the "sqlservr!CSbMsgDispatcher::CSbReceivedDialog::AppendMsg" class in SQL Server 2008 R2

831388

2653893   (http://support.microsoft.com/kb/2653893/ )

FIX: It takes a long time to restore a database in SQL Server 2008 R2

I hope this CU11 will fix the issue in relation to my previous blog post Linked Server reporte schema changes issue.

To download and further details refer to the KBA2633145  Cumulative update package 11 for SQL Server 2008 R2.

Published Tuesday, December 20, 2011 3:16 PM by ssqa.net

Comments

No Comments