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.
|VSTS bug number||KB article number||Description||Fix area|
|2578289||2881285||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 2014||Integration Services|
|2525262||2928300||FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server||SQL performance|
|2525267||2932559||FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014||Analysis Services|
|2594745||2933103||FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server||SQL performance|
|2594747||2936154||FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server||Management Tools|
|2556592||2936984||FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server||SQL service|
|2525271||2938192||FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014||Integration Services|
|2525280||2950209||FIX: Access violation when the start offset is larger than the string length in Substring function in SQL Server||SQL service|
|2525283||2952101||FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server||SQL performance|
|2594735||2953354||FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server||SQL service|
|2578277||2954861||FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012||Integration Services|
|2578296||2956619||FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system||Integration Services|
|2100367||2950189||FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server||SQL service|
|2578281||2957768||FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012||Reporting Services|
|2578275||2957957||FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel||Data Quality Services (DQS)|
|2525287||2958012||FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012||SQL service|
|2525285||2958062||FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014||SQL service|
|2578287||2959342||FIX: Data-driven subscription can't be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012||Reporting Services|
|2525278||2960237||FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server||DQS|
|2578299||2960310||FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server||SQL service|
|2525300||2960735||FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Microsoft Azure Virtual Machine gallery||Setup & Install|
|2525293||2960989||FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package||DQS|
|2525289||2961254||FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2||Analysis Services|
|2525296||2961525||FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application||Reporting Services|
|2578301||2961559||FIX: Incorrect folder when deploying SQL Server 2012 PowerPivot solutions by using SharePoint 2013 Central Admin||Analysis Services|
|2525298||2962650||FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014||Analysis Services|
|2578273||2963138||FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012||SQL service|
|2578303||2963372||FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012||Analysis Services|
|2594749||2963373||FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012||Analysis Services|
|2578279||2963377||FIX: Exception and access violation occurs when you run an MDX calculation in SSAS 2012||Analysis Services|
|2578284||2963836||FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012||Reporting Services|
|2512105||2965035||SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2||Analysis Services|
|2525264||2967634||FIX: SSIS 2012 or SSIS 2014 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation||Integration Services|
|2525291||2967635||FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS||DQS|
|2516114||2969023||FIX: The objects or tasks move to corner when you move or resize them in an SSIS 2012 package||Integration Services|
|2701948||2969896||FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014||SQL performance|
|2775472||2974948||FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012||Management Tools|
|2665730||2975402||FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server 2012||SQL service|
|2682780||2976172||FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS 2012||Analysis Services|
|2676516||2976861||FIX: The time is longer and longer to perform process full on an SSAS 2012 tabular model database||Analysis Services|
|2436389||2979587||FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server 2012||Setup & Install|
|2739737||2980208||FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server 2012||SQL service|
|2817693||2982843||FIX: Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and AlawysOn||High Availability|
Notes for this 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:
- SQL Server failover cluster rolling update and service pack process.
If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node (This step requests servicerestart).
- Upgrade and update of availability group servers that use minimal downtime and data loss.
If you enabled AlwaysOn with SSISDB catalog for additional considerations about how to apply a CU or SP in these environments, go and see the article from the following MSDN blog:
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation
Cumulative update package information
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2012 SP2.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2012.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.