KB2967540 - Cumulative update package 13 for SQL Server 2008 R2 SP2

Applies to: SQL Server 2008 R2 Service Pack 2SQL Server 2008 R2 EnterpriseSQL Server 2008 R2 Developer

This article describes cumulative update package 13 (Build number: 10.50.4319.0) for Microsoft SQL Server 2008 R2 Service Pack 2 (SP2). This update contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2 SP2.

Note This is the last cumulative update for SQL Server 2008 R2 SP2 since life cycle support ends for this release. For more information about the life cycle for SQL Server, check out the Microsoft product support life cycle information.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
19187792922526 FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscriptionSQL service
24637162926217 FIX: Performance problems occur when database lock activity increases in SQL ServerSQL service
25565892936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server 2008 or SQL Server 2008 R2SQL service
23714752939277 FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL ServerSQL performance
25252462952260 FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL ServerSQL service
22724162957174 FIX: Cannot create compressed nonclustered index on a table that has a clustered index with two or more bit columnsSQL service
25566002963408 FIX: Error 5180 occurs when you query BLOB column data in SQL ServerSQL service
24470112963658 FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL ServerSQL service
24420372963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitionsSQL service
24038312967103 FIX: Service broker stops working when you unregister and remove a session in SQL Server 2008 R2SQL service
24626042967240 FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL ServerSQL service
24516592971611 FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2Analysis Services
26260832973961 FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server 2008 R2SQL service
26915692975743 FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS 2008 R2Analysis Services
26244842977312 FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server 2008 R2SQL service

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • We recommend that you apply the most recent update release .
    • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
    • The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2008 R2 update release.
  • We recommend that you upgrade your SQL Server to the latest SQL Server 2008 R2 service pack .

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, mirroring, and cluster), we recommend that you refer to the following articles before you deploy them:  

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2008 R2 SP2.

Restart information

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

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.