Cumulative Update 1 for SQL Server 2012 SP2

This article describes cumulative update package 1 (Build number: 11.0.5532.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 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 numberDescriptionFix area
25782892881285 You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014Integration Services
25252622928300 FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL ServerSQL performance
25252672932559 FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014Analysis Services
25947452933103 FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL ServerSQL performance
25947472936154 FIX: DTA utility crashes with an access violation when you use user-defined function in SQL ServerManagement Tools
25565922936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL ServerSQL service
25252712938192 FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014Integration Services
25252802950209 FIX: Access violation when the start offset is larger than the string length in Substring function in SQL ServerSQL service
25252832952101 FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL ServerSQL performance
25947352953354 FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL ServerSQL service
25782772954861 FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012Integration Services
25782962956619 FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file systemIntegration Services
21003672950189 FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL ServerSQL service
25782812957768 FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012Reporting Services
25782752957957 FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server 2012 MDS Add-in for ExcelData Quality Services (DQS)
25252872958012 FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012SQL service
25252852958062 FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014SQL service
25782872959342 FIX: Data-driven subscription can't be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012Reporting Services
25252782960237 FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL ServerDQS
25782992960310 FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL ServerSQL service
25253002960735 FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Microsoft Azure Virtual Machine gallerySetup & Install
25252932960989 FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 packageDQS
25252892961254 FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2Analysis Services
25252962961525 FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms applicationReporting Services
25783012961559 FIX: Incorrect folder when deploying SQL Server 2012 PowerPivot solutions by using SharePoint 2013 Central AdminAnalysis Services
25252982962650 FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014Analysis Services
25782732963138 FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012SQL service
25783032963372 FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012Analysis Services
25947492963373 FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012Analysis Services
25782792963377 FIX: Exception and access violation occurs when you run an MDX calculation in SSAS 2012Analysis Services
25782842963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012Reporting Services
25121052965035 SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2Analysis Services
25252642967634 FIX: SSIS 2012 or SSIS 2014 XML validator only outputs "TRUE" or "FALSE" when you perform XML validationIntegration Services
25252912967635 FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDSDQS
25161142969023 FIX: The objects or tasks move to corner when you move or resize them in an SSIS 2012 packageIntegration Services
27019482969896 FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014SQL performance
27754722974948 FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012Management Tools
26657302975402 FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server 2012SQL service
26827802976172 FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS 2012Analysis Services
26765162976861 FIX: The time is longer and longer to perform process full on an SSAS 2012 tabular model databaseAnalysis Services
24363892979587 FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server 2012Setup & Install
27397372980208 FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server 2012SQL service
28176932982843 FIX: Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and AlawysOnHigh Availability

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 go and refer to the following articles before you deploy them:
Language support
Components updated
Support for this update
How to uninstall this update

Cumulative update package information

Prerequisites

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.
Cumulative update package file information
Properties

Article ID: 2976982 - Last Review: 9 Oct 2014 - Revision: 1

Feedback