INTRODUCTION
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. Note 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 number |
KB article number |
Description |
|---|---|---|
|
622431 |
FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008 |
|
|
621227 |
FIX: An embedded image of a report is incorrectly displayed as a red cross in SQL Server 2008 Reporting Services |
|
|
642793 |
FIX: Database mirroring session is suspended in SQL Server 2005 if the High-performance (asynchronous) mode is used |
|
|
649236 |
FIX: The memory usage in SSAS 2008 may be larger than in SSAS 2005 when you create a local cube |
|
|
561971 |
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, 621246 |
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 |
|
|
621919 |
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 |
|
|
621248 |
FIX: A SQL Server Agent job incorrectly runs after the specified end date in SQL Server 2008 |
|
|
642079 |
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 |
|
|
649235 |
FIX: Wrong email subscription is deleted when you use the SharePoint Integrated mode in SSRS 2008 if you sort the email subscriptions |
|
|
572004 |
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 |
|
|
628074 |
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 |
|
|
649218 |
FIX: 0xC002F325 error when you run two SSIS 2008 packages at the same time in SQL Server 2008 Integration Services |
|
|
632487 |
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 |
|
|
648196 |
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 |
|
|
648209 |
FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008 |
|
|
636021 |
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 |
|
|
649224 |
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 |
|
|
623572 |
FIX: An application crashes when it closes the last connection to a local cube file in SSRS 2008 R2 |
|
|
639010 |
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 |
|
|
639636 |
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 |
|
|
637780 |
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" |
|
|
635423 |
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 |
|
|
630300 |
"RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2 |
|
|
632713 |
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 |
|
|
649222 |
FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008 |
|
|
649233 |
"Non-yielding Scheduler" error and SQL Server 2008 stops responding intermittently in Windows Server 2008 |
|
|
627317 |
FIX: Error when you try to create an AMO, ADOMD.NET, or XMLA assembly in SQL Server 2008 R2 |
|
|
644831 |
The reports that are generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards |
|
|
645676 |
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 |
|
|
648675 |
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 |
|
|
646328 |
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 |
|
|
629581 |
FIX: You incorrectly receive a logon dialog box when you try to access a SQL Server 2008 R2 Reporting Services Report Manager website |
|
|
648630 |
FIX: "Report parameter values must be specified" error when you click a hyperlink in an email message to view a SSRS 2008 R2 report |
|
|
636807 |
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 |
|
|
647200 |
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 |
|
|
632667 |
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 |
|
|
647889 |
FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 |
|
|
646541 |
FIX: Broken Home link in the Report Explorer Web Part in SQL Server 2008 R2 Reporting Services |
|
|
649733 |
FIX: The Distinct Count measure may return incorrect values after you individually process partitions in SSAS 2008 R2 |
|
|
649672 |
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 |
|
|
656725 |
FIX: Performance issue in entity member creation when business rule validation is in progress in SQL Server 2008 R2 MDS |
|
|
653979 |
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:
-
In Control Panel, open the Add or Remove Programs item.
-
Click Change or Remove Programs .
-
To see all the updates for the SQL Server 2008 R2 installation, click to select the Show Updates check box.
-
Uninstall the cumulative hotfix package.
References
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:
935897 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:
822499 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:
824684 Description of the standard terminology that is used to describe Microsoft software updates
