Cumulative update package 7 for SQL Server 2012 SP1

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 DeveloperSQL Server 2012 Enterprise

This article describes cumulative update package 7 (Build number: 11.0.3393.0) for Microsoft SQL Server 2012 Service Pack 1 (SP1) . This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.

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.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescription
1282810 2792921 Description of new features in SQL Server 2012 and SQL Server 2008 R2 SP2
2833989 FIX: Object ID that is used in memory differs from the object ID on the disk in SQL Server 2012
2843619 Tablix column header sorting buttons are Section 508 noncompliant in a Reporting Services report in SQL Server 2012
2844210 FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer
2862241 FIX: Access violation when you trace an RPC event class by using SQL profiler or XEvents in SQL Server 2012
2866062 FIX: Access violation when you use DTA to analyze a database that contains a partition table in SQL Server 2008 R2 or in SQL Server 2012
2868348 FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS 2008 R2 or in SSRS 2012
2878968 FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012
2879373 FIX: The threads are not scheduled evenly in SQL Server 2012 Standard Edition
1455690 2881285 You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012
2881661 A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012
2883424 FIX: Dragged objects shake in an SSIS 2012 project after you apply Cumulative Update 6 for SQL Server 2012
2883524 FIX: "SCN not found" error when you use Connector for Oracle by Attunity and CDC for Oracle by Attunity in SQL Server 2012
2884953 FIX: "Non-yielding Resource Monitor" when you run a workload that executes concurrent queries in SQL Server 2012
2885671 Duplicated worksheets are opened when you use the SQL Server Master Data Services Add-in for Microsoft Excel in SQL Server 2012
2887115 FIX: Function sys.fn_hadr_backup_is_preferred_replica costs almost all the CPU usage in Log Shipping in SQL Server 2012
2887888 FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 instance
2887899 FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table
2888658 An access violation occurs when "sys.dm_db_index_physical_stats" is used in an IF EXISTS statement in an SQL query in SQL Server 2012
2889492 You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1
1519097 2889723 A series of errors occurs when you export a Reporting Services report as a PDF in SQL Server 2012
2890052 Integration Services catalog permissions don't work for Windows groups in SQL Server 2012
2890415 Notification messages are not received when data updates fail in a PowerPivot sheet in an instance of SQL Server 2012 Service Pack 1 Analysis Services
1482450 2891083 FIX: Subscriptions does not have an option to use default parameter values that are based on expressions in SSRS 2012 in SharePoint Integrated mode
2891088 FIX: Find option in Report Manager always takes you to the bottom of the page in SSRS 2012
2891230 FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2 or SSRS 2012
2893842 FIX: Fewer results in the MDS subscription view after you apply SQL Server 2012 SP1 or SQL Server 2012 CU2
2894025 Mirror tables are dropped when you use "Change Data Capture for Oracle by Attunity" on a server that is running SQL Server 2012
2894305 FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012
2894326 An application cannot connect to a contained database when connection pooling is enabled in SQL Server 2012
2895494 Slow SQL Server performance and a memory leak occurs after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1
2895694 FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012
2896505 Blank values for a DAX formula are seen in PowerPivot for Excel in SQL Server 2012 Analysis Services
2896720 FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table
2897221 Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012
2897237 FIX: Transaction date format on an MDS website in SQL Server 2012 differs from the format that is defined on the computer
2897263 "An error occurred when loading VertiPaq data" error occurs after you run DISCOVER_XML_METADATA Rowset or load a database and then start a trace in SQL Server 2012 Analysis Services
2897265 FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012
2897282 FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 on a non-US locale computer
2897454 FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012
2897512 FIX: Newly added member disappears from the Master Data Explorer in SQL Server 2012 MDS
2897539 FIX: IntelliSense feature does not work correctly after you type Transact-SQL statements in SSMS in SQL Server 2012
2897554 FIX: Synchronization state of an AlwaysOn Availability Group replica may not be updated if primary is unhealthy
2897633 FIX: You cannot start an audit by using an "ALTER" statement in SQL Server 2012
2899945 FIX: "The report server cannot process the report" error when you view an SSRS 2012 report on a SharePoint website
2900127 FIX: "PowerPoint was unable to open or save this document." error message after you modify an embedded PowerPivot table
2905275 FIX: "The operation was cancelled by the user" error message when you run some MDX or DAX queries in SSAS 2012
2905298 FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012

Notes for this update

Installation and deployment

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • 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 updates in this 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 2012 service pack that contains the hotfixes in this package.

Cumulative update

Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2012 update release. We recommend that you consider applying
the most recent update release .

Cumulative update package information


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

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.