INTRODUCTION
Cumulative Update 4 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.1746.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 4 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:
http://support.microsoft.com/contactus/?ws=support
SQL Server 2008 hotfixes that are included in Cumulative Update 4 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 |
|---|---|---|
| 549034 | none | CDC capture job can experience the following assert condition when you have CDC enabled on database tables which have XML or other blob datatype columns: Assertion: File: <file name> line=<line number> Failed Assertion = 'fNoWriters' -AND- line=<line number> Failed Assertion = 'fNoReaderWriterConflict' |
| 548984 | 980570 | FIX: "Fulltext index error during compression or decompression" error message when you rebuild the full-text search index in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 548986 | 980832 | FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 451119 | 980849 | FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 |
| 548988 | 981120 | FIX: Error message when you enable TDE on a database that has the snapshot isolation enabled in SQL Server 2008 or in SQL Server 2008 R2 |
| 548990 | 982034 | FIX: The translation feature does not work when you perform a grouping action in an Excel PivotTable that uses SSAS 2008 or SSAS 2008 R2 as the data source |
| 548996 | 982854 | FIX: "There is insufficient system memory in resource pool 'internal' to run this query" error message when you run a full-text query that uses compound words in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 548998 | 982857 | FIX: Error message when you configure a transactional replication for a database in SQL Server 2008 or in SQL Server 2008 R2 |
| 549014 | 983577 | FIX: The export process never finishes when you export a report that has nested tablix items in Microsoft SQL Server Reporting Services 2008 to the extensions that are supported by the hard page-break renderers |
| 442541 | 2022254 | SQL Server may report 18272 error during restore operations |
| 549019 | 2028406 | FIX: Blank spaces between some items are generated incorrectly in a SQL Server 2008 or a SQL Server 2008 R2 report |
| 549021 | 2028755 | FIX: An incorrect result is returned when you run a LIKE query with wildcards and the Latin1_General_100_CS_AS collation in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 549040 | 2200755 | FIX: Error message when you run a MDX query in SSAS 2008 or in SSAS 2008 R2 |
| 549042 | 2220252 | FIX: A SQL Server 2005 report that uses the visibility toggles feature runs incorrectly in SQL Server 2008 or in SQL Server 2008 R2 |
| 547877 | 2222998 | FIX: An incorrect cardinality estimate is returned when you run a query in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 |
| 549032 | 2248999 | FIX: An index corruption occurs when you update a view in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 549044 | 2255410 | A query returns inconsistent results before the data cache is warmed up in SSAS 2008 or in SSAS 2008 R2 |
| 561761 | 2261403 | FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008 or in SQL Server 2008 R2 |
| 549030 | 2264562 | FIX: A full-text query that uses CONTAINS or FREETEXT predicate together with the "OR" operator takes a long time to run in SQL Server 2008 or in in SQL Server 2008 R2 |
| 561767 | 2276330 | FIX: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2 |
| 519628 | 2276495 | FIX: "File system error" occurs when you try to run a process update operation on a dimension in Microsoft SQL Server 2008 R2 Analysis Services |
| 561769 | 2276717 | FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2005, Microsoft SQL Server 2008, and Microsoft SQL Server 2008 R2 |
| 561772 | 2278042 | FIX: A derived column transformation may generate incorrect results in SSIS 2008 or in SSIS 2008 R2 when a column is derived both in read-only usage and in read/write usage |
| 524544 | 2284503 | FIX: You encounter two issues when you use Microsoft SQL Server 2008 R2 Master Data Services (MDS) |
| 528558 | 2291551 | FIX: Error occurs when you try to configure a remote report server database by using Reporting Services Configuration Manager in the Datacenter edition of SQL Server 2008 R2 Reporting Services |
| 526900 | 2291705 | FIX: The AMO, ADOMD.NET, and XMLA assemblies for Microsoft SQL Server 2008 R2 have incorrect dependencies on the Microsoft.SharePoint.dll assembly and the Microsoft.AnalysisServices.SharePoint.Integration.dll assembly |
| 536667 | 2293053 | FIX: The column header ID incorrectly contains prefix information when you use the "ReportViewer" control of Visual Studio 2010 to run a report locally |
| 547891 | 2295869 | FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005 SP3 or in SQL Server 2008 R2 |
| 534262 | 2297308 | FIX: "A previous filestream configuration attempt was incomplete" error and an access violation occur when you perform post-setup configuration of the FILESTREAM feature on a SQL Server 2008 or SQL Server 2008 R2 failover cluster |
| 534101 | 2300689 | FIX: You cannot restore a backup of a database on another instance of SQL Server if you disable transparent data encryption before you create the backup in SQL Server 2008 or in SQL Server 2008 R2 |
| 544205 | 2344694 | FIX: Certain change tracking functions and DMVs do not work correctly after an automatic database mirroring failover occurs in SQL Server 2008 R2 |
| 536267 | 2359606 | FIX: "System.OverflowException: Value was either too large or too small for an Int32" error message occurs when you try to generate a report in Microsoft SQL Server 2008 R2 Reporting Services |
| 561798 | 2380361 | FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 or in SQL Server 2008 R2 if the table contains a nondeterministic computed column |
| 561800 | 2380435 | FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 |
| 561804 | 2384766 | FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008 or in SQL Server 2008 R2 |
| 561806 | 2387686 | FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008 or SQL Server 2008 R2 |
| 549656 | 2397020 | FIX: "Access is denied. [0x80070005]" error message occurs in SSCM when you try to change the password of an account of SQL Server 2008 R2 in Windows Vista or in a later version of Windows |
| 548720 | 2401453 | FIX:"Search failed: Failed to retrieve data for this request" message when you search for some SQL Azure database objects in the "Object Explorer Details" tab of SQL Server 2008 R2 Management Studio |
| 554322 | 2407088 | FIX: "Sys.ArgumentNullException" error occurs when you open a drillthrough report in a Report Viewer Web part if you use the SharePoint Integrated mode in SQL Server 2008 R2 Reporting Services |
| 555924 | 2410425 | FIX: You receive an exception when you try to create an MDS database in SQL Server 2008 R2 MDS if a non-MDS database table is named "tblSystem" |
| 555933 | 2412136 | FIX: The Entities Explorer grid displays few rows in a SQL Server 2008 R2 MDS website if you use a low screen resolution |
| 560368 | 2421014 | FIX: "A severe error occurred on the current command" error message when you use the Freetexttable or the Containstable function on an indexed view in a CTE query in SQL Server 2008 R2 |
| 554345 | 2428397 | FIX: "Type mismatch" error message occurs when you try to delete an embedded PowerPivot database from an instance of SQL Server 2008 R2 Analysis Services that is installed in the SharePoint Integration mode |
| 558922 | 2431362 | FIX: Error message when you try to create a named query in a project that uses Microsoft SQL Server 2008 R2 Parallel Data Warehouse as data source: Keyword not supported |
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