KB2908087 - Cumulative update package 10 for SQL Server 2008 R2 SP2

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

This article describes cumulative update package 10 (Build number: 10.50.4297.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.

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 numberDescription
12580052297709 FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008 or in SQL Server 2008 R2
16112782532079 FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2
15904382671078 FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012
15023692888996 FIX: Data purity corruption in table sys.sysbinobjs on MASTER database when you log on SQL Server 2008 R2 by using SA account and run the DBCC CHECKDB statement
16105432889492 You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1
15191162891115 FIX: "The search text was not found" error when you search specific formatting numeric values from a report in SSRS 2008 R2
15402522891489 FIX: The replication Log Reader Agent fails when you enable CDC and Transaction Replication for some columns in SQL Server 2008 R2
15606302892741 FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012
16723822895694 FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012 or in SSAS 2008 R2
16501492902858 FIX: SSIS package will never stop running when the package contains a Fuzzy Lookup task from BIDS in SQL Server 2008 R2
16590592904010 FIX: A small number of rows are sampled in SQL Server 2008 R2 when table statistics are updated automatically or together with specified sampling rate
17481082911026 FIX: Access violation when you query sys.dm_server_memory_dumps in SQL Server 2008 R2
17139892911385 FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2
17652072912949 FIX: SSAS crashes when there are more than one threads try to access a SSAS 2008 R2 cube at the same time
17424572913206 FIX: Cannot pass report parameters to Reports in SharePoint Document Library in SSRS 2008 R2 by using HTML forms

Notes for this update

Installation and deployment

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • 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 updates in this package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for
    the next SQL Server 2008 R2 service pack that contains the hotfixes in this package.

Cumulative update

Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 R2 update release. We recommend that you consider applying
the most recent update release .

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.