Cumulative Update package 7 for SQL Server 2012 Service Pack 2

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 Business IntelligenceSQL Server 2012 Enterprise

This article describes Cumulative Update package 7 (Build number: 11.0.5623.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.

SQL Server 2012 SP2 Cumulative Update 7 contains the recently released Security Bulletin MS15-058 (KB3065718 ). If you have not installed that security update, you can install Cumulative Update 7 without installing Update 3065718. Cumulative Update 7 will install all the hotfixes that are addressed in Security Bulletin MS15-058.

How to obtain this cumulative update package

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

Known Issue

After installing this CU, Change Data Capture (CDC) functionality might break if :

  • The databases enabled for CDC are part of Always On availability group (or)
  • SQL Server replication components are not installed on the server

For more information, see:

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
39831913029096FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly Integration Services
43466133030352FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 database SQL service
41786333052461FIX: Some attributes in element are ignored when you transform XML file in SSIS 2012 Integration Services
46397623062001FIX: "Failed to create kernel event for collection set" error occurs when you use Data Collection in SQL Server 2012 Management Tools
46020463061215FIX: "Cannot read 8 bytes from file" error occurs when you use SSIS 2012 Integration Services
47135473064454FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 SQL performance
47152063065060FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS Management Tools
47433303068351FIX: ROLAP Distinct Count on data source is not started when it is running from SSAS 2012 to back-end SQL Server 2014 Analysis Services
46625563068359FIX: "Cannot find the OLAP cube Model" error when you update the pivot table in a SharePoint document in SQL Server 2012 Analysis Services
45209053068439FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012 SQL performance
46943483068468FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012 SQL service
48045693068703FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 SQL service
48059763068776FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 SQL performance
45245353069154FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only SQL service
44367703069155FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service
49254133073530FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 Analysis Services
45003073074434FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
49286773074535FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server SQL service
46833213074922FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 SQL performance
45470543074425FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012 SQL service
50133833075176FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database SQL service
44951333076444FIX: Cannot enable "change data capture" on a table that uses a unique index with more than one included column in SQL Server 2012 SP2 SQL service
47818573075669FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions Analysis Services
43769573051243FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
47052493064292FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 SQL service
49338963073907FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding Analysis Services
46917463063438FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
47163422965654FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
49391753070147Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server SQL service
47592093066299FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
48173233069320FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 Master Data Services to start the workflow MDS
4465179972759FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem Management Tools
48342212820068Can't install SQL Server by using InstallShield or bootstrapping application Setup & Install
5285700321185This 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 the following query:

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 3 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 is intended to correct 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 with the previous SQL Server 2012 update release.
  • We recommend that you upgrade your 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 first refer to the following articles:

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.