Cumulative update 8 for SQL Server 2014 SP1

This article describes cumulative update package 8 (build number: 12.0.4468.0) for Microsoft SQL Server 2014 Service Pack 1 (SP1). This update contains fixes that were released after the release of SQL Server 2014 SP1.

Cumulative update

Cumulative updates are now available at the Microsoft Download Center.

Only the most recent cumulative update (CU) that was released for SQL Server 2014 SP1 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 .

How to obtain this cumulative update package

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.

The Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack is a stand-alone package that provides additional value for SQL Server Integration Services (SSIS).

Download Download the Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack package now.

Note After future CUs are released for SQL Server 2014 Service Pack 1, this CU can be downloaded from the Microsoft Windows Update Catalog. However, we recommend that you install the latest CU that's available.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
76790053157575FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server 2012 or 2014 Management Tools
76789843160407FIX: sys.dm_db_index_usage_stats missing information after index rebuild on SQL Server 2012 or 2014 SQL performance
76836783179596"Failed Assertion = 'm_pExclusiveOwner != pWorker'" is continuously logged in the SQL Server 2014 error log SQL service
79907123166545FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
77317303168740An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 Integration Services
76789733162396FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
77292073170051FIX: SQL Server 2012 failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting High Availability
79532563174370A memory leak occurs when you use Azure Storage in SQL Server 2014 SQL service
78728403178526An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 SQL connectivity
74256103178107SQL Server 2014 crashes because of an access violation error that occurs while it reads data from an event file target SQL service
76789893149128Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server SQL security
79429673181260SQL Server Analysis Services crashes when you belong to multiple roles and execute a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
76789793152965FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server High Availability
76789263152596FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Reporting Services
79194123180263FIX: It takes a long time to cancel a query in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
75965133164104Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
76003913164404FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
75872293176440FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 SQL service
73079973153836Operating system error 32 when you restore a database in SQL Server 2014 SQL service
78327673174476FIX: Deadlock occurs when you acquire a SCH-M lock and ALTER PARTITION in SQL Server 2014 SQL service
76943353160874FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition Analysis Services
78374653181444FIX: Queries always get recompiled on the secondary databases in SQL Server 2014 High Availability
76789123152042FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Reporting Services
58149803181526The calculation of two measure time values in iterations returns a negative value in SQL Server 2014 SQL service
76789933155558FIX: "Cannot alter column" error after a database is restored to SQL Server SQL service
77812403177132FIX: Garbage collection in In-Memory OLTP may cause "non-yielding scheduler" in SQL Server 2014 In-Memory OLTP
79906833150432Performance of Analysis Services in Multidimensional mode degrades over time Analysis Services
75429343161403The file size of the PDF file generated by SQL Server 2014 Reporting Services is larger when compared to the earlier versions of SQL Server Reporting Services
76367563165168Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server 2014 SQL service
77001543167159FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan SQL performance
76943283155209FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 SQL service
78654893025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
78436603175883Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server SQL performance
76789423154226FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server SQL service
79906863171896Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas in SQL Server High Availability
77928133171681Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
79077683176993FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 Reporting Services
72496563145492FIX: XA transactions aren't cleaned when you exit a Java application in an instance of SQL Server SQL service
78116803173471FIX: Error 3456 "Could not redo log record" occurs, causing replicas to be suspended or repeated behavior in SQL Server SQL 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:

Language support
Components updated
Support for this update
How to uninstall this update

Cumulative update package information


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

文書番号:3174038 - 最終更新日: 2017/01/06 - リビジョン: 1