KB4040713 - Cumulative Update 8 for SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

This article describes cumulative update package 8 (build number: 13.0.2213.0) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

Cumulative update

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

Only the most recent CU that was released for SQL Server 2016 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 2016 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.

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

Hotfixes that are included in this cumulative update package

VSTS bug number KB article number Description Fix area
10729319 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Reporting Services
10817781 4040276 FIX: Indirect checkpoints on the tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 SQL Engine
10682296 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server 2014 or 2016 is also installed Data Quality Services (DQS)
10682302 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server 2014 or 2016 SQL Engine
10682256 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server SQL Engine
10682300 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 or 2016 SQL Engine
10716344 4039966 FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 SQL Engine
10729323 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 or 2016 High Availability
10679744 4040533 FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 SQL Engine
10682282 4024563 FIX: Unhandled exception when you export a SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 or 2016 Reporting Services
10682251 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 SQL Engine
10479291 4034789 FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 Analysis Services
10682270 4022753 FIX: SSAS 2014 or 2016 crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Analysis Services
10682266 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 SQL Engine
10682259 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Management Tools
10682322 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server 2016 SQL Engine
10271367 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 SQL Performance
10988058 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Integration Services
10988062 4038932 FIX: Change Data Capture functionality does not work in SQL Server Change Data Capture

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


To apply this cumulative update package, you must be running SQL Server 2016.

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.