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.
|VSTS bug number||KB article number||Description|
|1258005||2297709||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|
|1611278||2532079||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|
|1590438||2671078||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|
|1502369||2888996||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|
|1610543||2889492||You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1|
|1519116||2891115||FIX: "The search text was not found" error when you search specific formatting numeric values from a report in SSRS 2008 R2|
|1540252||2891489||FIX: The replication Log Reader Agent fails when you enable CDC and Transaction Replication for some columns in SQL Server 2008 R2|
|1560630||2892741||FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012|
|1672382||2895694||FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012 or in SSAS 2008 R2|
|1650149||2902858||FIX: SSIS package will never stop running when the package contains a Fuzzy Lookup task from BIDS in SQL Server 2008 R2|
|1659059||2904010||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|
|1748108||2911026||FIX: Access violation when you query sys.dm_server_memory_dumps in SQL Server 2008 R2|
|1713989||2911385||FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server 2008 R2|
|1765207||2912949||FIX: SSAS crashes when there are more than one threads try to access a SSAS 2008 R2 cube at the same time|
|1742457||2913206||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.
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 .
the most recent update release .
Cumulative update package information
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2008 R2 SP2.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2008 R2.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.