Cumulative Update package 6 for SQL Server 2008 R2

Taikoma: SQL Server 2008 R2 DatacenterSQL Server 2008 R2 DeveloperSQL Server 2008 R2 Enterprise


Cumulative Update 6 contains hotfixes for the Microsoft SQL Server 2008 R2 issues that have been fixed since the release of SQL Server 2008 R2.

This build of this cumulative update package is also known as build 10.50.1765.0 .

We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

Important notes about the cumulative update package

  • The hotfixes in this cumulative update package is included in SQL Server 2008 R2 Service Pack 1 (SP1) .
  • SQL Server 2008 R2 hotfixes are now multilanguage. Therefore, there is only one cumulative hotfix package for all languages.
  • One cumulative hotfix package includes all the component packages. The cumulative update package updates only those components that are installed on the system.

More Information

How to obtain Cumulative Update 6 for SQL Server 2008 R2

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update 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 cumulative update package.

If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:

SQL Server 2008 hotfixes that are included in Cumulative Update 6 for SQL Server 2008 R2

Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.

For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
VSTS bug numberKB article numberDescription
622431980350 FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008
6212272401548 FIX: An embedded image of a report is incorrectly displayed as a red cross in SQL Server 2008 Reporting Services
6427932403218 FIX: Database mirroring session is suspended in SQL Server 2005 if the High-performance (asynchronous) mode is used
6492362422081 FIX: The memory usage in SSAS 2008 may be larger than in SSAS 2005 when you create a local cube
5619712424346 FIX: Report is not displayed correctly on a Report Viewer web part when you select "Adjust height to fit zone" in SSRS 2008 R2
621243, 6212462433265 FIX: You may receive an incorrect result when you run a query that uses the ROW_NUMBER function together with a left outer join in SQL Server 2008
6219192435404 FIX: Computer stops responding when you create a database that contains a FILESTREAM filegroup in SQL Server 2008 R2 if a third-party mini-filter driver is installed
6212482435844 FIX: A SQL Server Agent job incorrectly runs after the specified end date in SQL Server 2008
6420792451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005 and in SQL Server 2008
6492352454175 FIX: Wrong email subscription is deleted when you use the SharePoint Integrated mode in SSRS 2008 if you sort the email subscriptions
5720042455009 FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005 or in SQL Server 2008
6280742472573 FIX: "Cannot connect to data source '*.xlsx'" error when you try to connect to a PowerPivot gallery workbook by using Report Builder 3.0 in SSRS 2008 R2 SharePoint integrated mode
6492182478032 FIX: 0xC002F325 error when you run two SSIS 2008 packages at the same time in SQL Server 2008 Integration Services
6324872479681 FIX: "An item with the same key has already been added" error when you export a report to a PDF or TIFF file in SQL Server 2008 Reporting Services
6481962480368 FIX: SSAS 2008 crashes after a ProcessFull operation is performed on a measure group for a server-based cube if SSAS tries to clean a session that contains a session cube
6482092481245 FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008
6360212481926 FIX: "#ERROR" error when you generate a Hyperion Essbase-based report in SQL Server 2008 R2 Reporting Services if a field name contains a dot character
6492242482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string
6235722483381 FIX: An application crashes when it closes the last connection to a local cube file in SSRS 2008 R2
6390102485396 FIX: Error when you use a hard page-break renderer to export a report in SSRS 2008 R2 if the HideDuplicates property is not set to None
6396362486113 A drop-down list is always displayed instead of a search box when you double-click the value of the filter criteria box for an attribute in Entities Explorer of the SQL Server 2008 R2 MDS website
6377802486777 FIX: Error message when you display a drillthrough report in the Report Viewer web part control in Microsoft SQL Server 2008 R2 Reporting Services in SharePoint Integrated mode: "rsExecutionNotFound"
6354232486793 FIX: The parent report incorrectly contains the parameters of child report when you click "Go back to the parent report" in SSRS 2008 R2 SharePoint integrated mode
6303002487231 "RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2
6327132490555 FIX: Data update does not occur daily in SQL Server 2008 R2 PowerPivot for SharePoint if business hours are set to end the next day
6492222491210 FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008
6492332491214 "Non-yielding Scheduler" error and SQL Server 2008 stops responding intermittently in Windows Server 2008
6273172491439 FIX: Error when you try to create an AMO, ADOMD.NET, or XMLA assembly in SQL Server 2008 R2
6448312492027 The reports that are generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards
6456762492329 FIX: Decrease in rendering performance for SQL Server 2008 R2 Reporting Services in SharePoint Integrated mode when a report contains expressions in "Go to URL" actions
6486752492381 FIX: SQL Server 2008 R2 performs poorly when most threads wait for the CMEMTHREAD wait type if the threads use table variables or temp tables to load or update rowsets
6463282493229 FIX: Unexpected null values may appear when you import or refresh data in a PowerPivot for Excel 2010 workbook that was published on a SharePoint site
6295812494447 FIX: You incorrectly receive a logon dialog box when you try to access a SQL Server 2008 R2 Reporting Services Report Manager website
6486302495303 FIX: "Report parameter values must be specified" error when you click a hyperlink in an email message to view a SSRS 2008 R2 report
6368072496707 FIX: Ragged hierarchy members cannot be referenced by using the "Name Style 2" method in an MDX query for SQL Server 2008 R2 Analysis Services
6472002497301 FIX: "Validate Version" page takes a long time to open or times out after you click "Validate version" on the SQL Server 2008 R2 MDS website
6326672498796 FIX: An access violation may occur when you update the statistics of a table after you enable and then disable conflict detection on a table in SQL Server 2008 R2
6478892498839 FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2
6465412498880 FIX: Broken Home link in the Report Explorer Web Part in SQL Server 2008 R2 Reporting Services
6497332501558 FIX: The Distinct Count measure may return incorrect values after you individually process partitions in SSAS 2008 R2
6496722503278 FIX: Incorrect result of a calculated member that references another calculated member if the referenced calculated member is used in a Filter function in SSAS 2008 R2
6567252504112 FIX: Performance issue in entity member creation when business rule validation is in progress in SQL Server 2008 R2 MDS
6539792504524 FIX: "Bad variable type" or "Type mismatch" error when you run an UPDATE CUBE statement to alter the value of a null cell in a writeback-enabled cube in SSAS 2008 R2

Cumulative update package information

Restart information

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

Registry information

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

How to uninstall the cumulative update package

To uninstall the cumulative update package, follow these steps:
  1. In Control Panel, open the
    Add or Remove Programs
  2. Click
    Change or Remove Programs
  3. To see all the updates for the SQL Server 2008 R2 installation, click to select the
    Show Updates
    check box.
  4. Uninstall the cumulative hotfix package.


For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems

For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
Description of the standard terminology that is used to describe Microsoft software updates