Cumulative update package 9 for SQL Server 2012 SP2

Koskee seuraavia: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Analysis Services

This article describes cumulative update package 9 (build 11.0.5641.0) for Microsoft SQL Server 2012 Service Pack 2 (SP2). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP2.

How to get this cumulative update package

Click "Hotfix Download Available" at the top of this Microsoft Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to get the cumulative update package.  

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
57253833102243FIX: The version and the version flag properties of a subscription view can't be updated correctly in MDS 2012 Master Data Services (MDS)
55143463103293FIX: Error 17066 occurs during the encryption operation when you use TDE in SQL Server 2012 SQL service
58354243103472FIX: The SQL Server service performs more I/O operations on the mirror server than on the principal server High Availability
56895133103644SQLTables function and sp_tables stored procedure don't require SELECT permission any longer on user tables and views SQL security
56867873101120FIX: SQL Server stops responding when you back up the certificate that is used to encrypt the database encryption key in SQL Server 2012 SQL service
56418713103016FIX: SSRS stops responding when you try to export a report to a .pdf document in SQL Server 2012 Reporting Services
42724692682488FIX: Backup operation fails in a SQL Server database after you enable change tracking SQL service
48120023082877FIX: No error is prompted when a connection is ended in sqlcmd  SQL service
56469933097636FIX: Performance decrease when an application that has connection pooling frequently connects or disconnects in SQL Server SQL service
56995333051145FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014 SQL service
55443283097970FIX: Sp_describe_undeclared_parameters returns incorrect result when the undeclared parameter targets a decimal column SQL service
56877972835348Update improves the Service Broker when you send messages to remote servers in SQL Server 2012 and SQL Server 2014 SQL service
5285719321185This update introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:
Additionally, this update also adds the CU number information to the first line of the SQL Server error log.
For more information, review Methods 2 through Method 4 under the section How to determine which version and edition of SQL Server Database Engine is running in How to determine the version and edition of SQL Server and its components.

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • We recommend that you apply the most recent update release .
    • This cumulative package fixes only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
    • The most recent update release  contains all the hotfixes and all the updates that were included in the previous SQL Server 2012 update release.  
  • We recommend that you upgrade your instance of SQL Server to  the latest SQL Server 2012 service pack .

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, mirroring, and cluster), we recommend that you refer to the following articles before you deploy the hotfixes:  

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2012 SP2.

Restart information

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

Registry information

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