Cumulative Update 5 for SQL Server 2014 SP2

Applies to: Microsoft SQL Server 2014 Service Pack 1SQL Server 2014 EnterpriseSQL Server 2014 Express More

This article describes cumulative update package 5 (build number: 12.0.5546.0) for Microsoft SQL Server 2014 Service Pack 2 (SP2). This update contains fixes that were released after the release of SQL Server 2014 SP2.

Cumulative update

Cumulative updates (CU) are now available at the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2014 SP2 is available at the Download Center.

  • Each new CU contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:

    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.
  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2014 service pack.
The following update is available from the Microsoft Download Center:


If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note After future cumulative updates are released for SQL Server 2014 SP2, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

Additional hotfixes that are included in this cumulative update package


VSTS bug numberKB article numberDescriptionFix area
96273634016945FIX: "The custom resolver for this article requires OLEAUT32.DLL with a minimum version of 2.40.4276" error occurs when you use merge publication in SQL Server 2014SQL service
96467754019603FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014Analysis Services
96157964014327FIX: Access violation in SQL Server 2014 when large number of rows are inserted into a partitioned columnstore indexSQL services
94313563210089GDR update package for SQL Server 2016 SP1Reporting Services
97192804016361FIX: Service Broker endpoint connections aren't closed after an availability group failover in SQL ServerSQL service
93989234014862FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016Reporting Services
94794414013585FIX: SQL Server 2014 Analysis Service proactive caching processes a partition but does not run an SQL query which causes stale dataAnalysis Services
92788094013236FIX: Bad query plan created on secondary replicas after statistics updated via FULLSCAN option on primary replica in SQL Server 2012 or 2014High Availability
93856204011477FIX: DMF sys.dm_db_incremental_stats_properties does not show all partitions if the partitioning column is set to a character or binary data typeSQL performance
95032484009823FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 or 2016SQL performance
95031803208276Update improves handling of documents too large for Full-Text Search indexing in SQL ServerSQL service
97313714017063FIX: Runaway MDX query that uses Value() function in SSAS 2014 can rapidly and completely consume all the server memory and cause the server to hangAnalysis Services
98138324014756FIX: SQL Server Profiler fails to obfuscate sp_setapprole when it's executed from a remote procedure call in SQL Server 2012 or 2014SQL service
98138644014738FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server 2012 or 2014SQL service
94036795852300FIX: SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE commandSQL service
98138274013111FIX: DMV sys.dm_hadr_availability_group_states displays "NOT_HEALTHY" in synchronization_health_desc column on secondary replicas in SQL Server 2012 or 2014High Availability
98138604014706FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server 2012 or 2014SQL service
97208574016238FIX: DBCC CLONEDATABASE is unsuccessful if the source database has an object that was originally created in an instance of SQL Server 2000SQL service
98138564014798Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server 2012 or 2014SQL service
96968644017022FIX: Many HkHostLogCheckpointRecord() messages are logged in the SQL Server error logIn-Memory OLTP
98138234014732FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server 2012 or 2014SQL service
97754894017023FIX: SQL Server 2014 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2SQL service

Notes for this update


Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the hotfixes:

Cumulative update package information


Prerequisites

To apply this cumulative update package, you must be running SQL Server 2014 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.