Cumulative Update package 3 for SQL Server 2008 R2

INTRODUCTION

Cumulative Update 3 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.1734.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 3 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 3 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
458389979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication
450651980142 FIX: You receive a "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services
459186981811 FIX: An error occurs when you update the schema of objects that are in a published database in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2
459854981814 FIX: SSMS Object Explorer does not display the correct version number for SSIS or for SSRS
470559981881 FIX: "The selected data extension <data extension name> cannot be loaded" error message when you use Report Builder 2.0 to run an SSRS 2008 or SSRS 2008 R2 report that uses a custom data processing extension in server mode
459191981888 FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2
510793982363 FIX: SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 may require a long time to complete an ALTER TABLE statement that alters an XML data type column from "NOT NULL" to "NULL" in a table
510788982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
510795983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
510805983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled
510809983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
5228092121407 FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 R2
5010902142496 FIX: A SQL Server 2008 R2 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table
5054862225696 FIX: You fail to import data table from SQL Server by using PowerPivot in Excel 2010
5044252269585 FIX: SharePoint services and SharePoint Server Enterprise Site Collection features are disabled after you uninstall the PowerPivot for SharePoint component on a computer that is running SQL Server 2008 R2
5172782270925 FIX: PowerPivot workbooks are always loaded to the PowerPivot server that is last added to the SharePoint farm despite the use of server health based allocation or round-robin allocation
5195232276203 FIX: It takes a long time to open a SQL Server 2008 R2 Reporting Services report that contains many parameter values in Internet Explorer
5202132277078 FIX: The TokenAndPermUserStore cache store size continues to grow when you enable a SQL Server audit in SQL Server 2008 R2
4994452282505 FIX: Business Intelligence Development Studio 2008 R2 does not generate an RDL.DATA file when you preview a SQL Server report
5241532283036 FIX: Forms-based authentication does not work in SQL Server 2008 R2 Reporting Services
5241602283051 FIX: "The item '/微软丬国' cannot be found. (rsItemNotFound)" error message when you click the Folder Settings button in Microsoft SQL Server 2008 R2 Reporting Services
5241752283072 FIX: A hotfix is available that enables SQL Server 2008 R2 Reporting Services to use a 2048-bit RSA key to encrypt a Reporting Services key for FIPS compliancy
5241832283091 FIX: BIDS crashes when you use the Map Layer wizard to add sptial data in SQL Server 2008 R2 Reporting Services
5242112283186 FIX: "Requested value 'Unknown' was not found" error message when you update a parameter for a SQL Server 2008 R2 report in SharePoint Server 2010
5037212285711 FIX: A fix is available that improves the manageability of SSMS 2008 R2 to support Spatial Types for SQL Azure
5037182285720 FIX: A fix is available for SQL Server Management Studio 2008 R2 that enables you to rename SQL Azure databases in Object Explorer
4996412290377 FIX: The Report Definition Customization Extension does not modify the RDL file as expected in SQL Server 2008 R2
4689192292807 FIX: "USE statement is not supported to switch between databases" error message when you run a custom report in SQL Server 2008 R2 Management Studio
5278372297903 FIX: Event ID 322 is logged when a server audit is outputted in SQL Server 2008 R2
5366962315727 FIX: You cannot create, add, or edit steps for an SQL Server Agent job in SQL Server Management Studio 2008 R2
5082172268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005

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
    item.
  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.

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
Propiedades

Id. de artículo: 2261464 - Última revisión: 16 oct. 2013 - Revisión: 1

Comentarios