Cumulative update 5 for SQL Server 2012 SP2

Applies to: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Express
Update Available
This article describes cumulative update package 5 (Build number: 11.0.5582.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
40342652989043FIX: Access denied when you view report history on a SharePoint site with the View Items permission Reporting Services
40672643016165FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server SQL service
37462153020350FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages in SSIS 2012 Integration Services
40672563023629FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models Analysis Services
40672593026082FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
40672623026083FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
40672743028322FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014 Reporting Services
39954943029776FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
39809763032476FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012 SQL service
40582853033041FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source Integration Services
40778573034492FIX: "Call to Excel Services returned an error" error when you refresh the document in the PowerPivot Gallery Analysis Services
41249693034679FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING High Availability
39877843036201FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 MDS Master Data Services (MDS)
40195033037624FIX: Complex parallel query does not respond in SQL Server 2012 SQL performance
41386023038267FIX: Error "[BC30494] line is too long" occurs when you upload an SSRS 2012 report to Reporting Service Report Manager Reporting Services
40010043038331FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS 2012 Reporting Services
41110943038332FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports Reporting Services
41368273038943FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups High Availability
41422513039035FIX: "Parameter type cannot be deduced" when you execute sp_describe_undeclared_parameters in SQL Server 2012 SQL service
41665673040675FIX: Data-driven subscription with email notification shows "0 errors" when email delivery fails in SSRS 2012 Reporting Services
41665343040804FIX: "Access Denied" error occurs when you run an XML validation task in SSIS 2012 Integration Services
41666593041056FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2 Reporting Services
41684903041859FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application SQL connectivity
42037213042007FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle SQL service
41421913042077FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 Analysis Services
40735473042135FIX: Access violation and "No exceptions should be raised by this code" error occur when you use SQL Server 2012 SQL service
4049132 3044958FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails SQL service

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:

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.

References