Cumulative Update 7 for SQL Server 2016

Cumulative Update 7 (CU7) for Microsoft SQL Server 2016 was also released as a SQL Server Security Bulletin on 8/8/2017, KB4019086. See CVE-2017-8516 for more information. Because of this, you may already have CU7 installed as part of that security bulletin release and installation of this CU is unnecessary. If you do try to install CU7 after CVE-2017-8516, you may receive the following message:

There are no SQL Server instances or shared features that can be updated on this computer

This indicates that CU7 is already installed and no further action is required.

Note The package name for CU7, "SQLServer2016-KB4024304-<x86/x64>.exe", contains the CVE-2017-8516 KB number (4019086), not the CU7 KB number, (4024304). This can be ignored as a single package services both release channels.

This article describes cumulative update package 7 (build number: 13.0.2210.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:

Download the latest cumulative update package for SQL Server 2016 now.

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
10029683	4018227	FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server	High Availability
10015189	4038210	FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed	SQL service
10163598	4023995	FIX: Data mask on a floating points column is removed unexpectedly in SQL Server 2016	SQL security
10049123	4013585	FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data	Analysis Services
10049112	4011477	FIX: DMF sys.dm_db_incremental_stats_properties doesn't show all partitions if partitioning column is set to character or binary data type	SQL performance
10049133	4017023	FIX: SQL Server 2014 or 2016 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2	SQL service
10297645	4025402	FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2016	Analysis Services
10420071	4034376	FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server 2016	SQL service
10049114	4014862	FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016	Reporting Services
9995483	4023138	FIX: Incorrect syntax error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server	SQL service
10029656	4017080	FIX: Transaction log backup failure on the secondary replica in SQL Server Always-On Availability Groups	High Availability
10018568	4022435	FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016	SQL performance
9983973	4021580	Fix: System generated stored procedures are created incorrectly in P2P publication if the schema name of published table contains a period (.) in SQL Server 2014 or 2016	SQL service
10029670	4019125	FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column	XML
10029674	4019983	FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report	Reporting Services
10029664	4015561	FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server	SQL service
10087725	4023865	FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server 2016 MDS	Data Quality Services (DQS)
10242547	4024184	FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016	SQL service
10107255	4023419	FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it's compared to SQL Server 2008 R2	SQL performance
10029679	4017827	FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset"	Reporting Services
10375302	4034056	FIX: Access violation occurs when you execute a query in SQL Server 2016	SQL service
10049121	3210089	GDR update package for SQL Server 2016 SP1	Reporting Services
10048665	4016804	FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016	Integration Services
10018516	4024449	FIX: Databases on secondary replica shows "NOT SYNCHRONIZING" status after failover in SQL Server 2016	High Availability
10049127	4019603	FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016	Analysis Services
10015189	4018930	Update adds the "CLR strict security" feature to SQL Server 2016	SQL Service
10268792	4025628	FIX: Error 9004 when you try to restore a compressed backup from multiple files for a large TDE-encrypted database in SQL Server	SQL service
10351981	4032200	FIX: Fail to compress the backup file when INIT and COMPRESSION option is used in a TDE enabled database in SQL Server 2016	SQL service
10273870	4024989	FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error when you execute a BULK INSERT statement in SQL Server	SQL service
10351966	4019893	FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016	SQL service
9876047	4018908	FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model)	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: