Related topics
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

This article describes Cumulative Update package 7 (CU7) (build number: 13.0.5337.0) for Microsoft SQL Server 2016 Service Pack 2 (SP2). This update contains fixes that were released after the initial release of SQL Server 2016 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 2016 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 2016 service pack.

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:

Download icon  Download the latest cumulative update package for SQL Server 2016 SP2 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, we recommend that you always install the latest cumulative update that is available.

Additional hotfixes that are included in this cumulative update package

VSTS bug number

KB article number


Fix area



FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014 and 2016

Integration Services



FIX: Repl_Schema_Access wait issues when there are multiple publisher databases on the same instance of SQL Server 2016

SQL Engine



FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014 and 2016

SQL performance



FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016

SQL performance



FIX: Access violation occurs when you query sys.dm_hadr_availability_replica_states in SQL Server 2016

High Availability



FIX: Floating point exception error 3628 occurs when you query DMV sys.dm_db_xtp_hash_index_stats in SQL Server 2016

In-Memory OLTP



FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016

High Availability



FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016

SQL Engine



FIX: HTML files cannot be opened directly from the web portal in SSRS 2016

Reporting Services



FIX: Access violation occurs when you run a query against sys.availability_replicas in SQL Server 2016

High Availability



FIX: Adding new Publication may fail if distribution database is in AG and collation is set to BIN in SQL Server 2016

SQL Engine



FIX: Remote ad hoc queries that use OPENDATASOURCE produce an incorrect error message when the new OLE DB provider is used

SQL Engine



FIX: Database may crash when multiple threads update permissions on the same database in SQL Server 2016

Analysis Services



FIX: Query against table with both clustered columnstore index and nonclustered rowstore index may return incorrect results in SQL Server 2016

SQL Engine



FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014 and 2016

High Availability



FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014 and 2016

SQL Engine



FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016

SQL Engine



FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014 and 2016

SQL Engine



FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2016

SQL Engine



FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016

High Availability



Improvement: Enable PDW APS to access TRY_CONVERT() function in SQL Server 2016

SQL Engine



Fix: "Non-yielding Scheduler" occurs when you clean up in-memory runtime statistics of Query Store in SQL Server 2016

SQL Engine



FIX: URL encoding is incorrect when the Excel workbook name is in Russian language in SSRS 2016

Reporting Services



FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016

High Availability



FIX: SQL Server 2016 does not perform the requested pre-row assignments when you use MERGE statement that performs assignments of local variables for each row

SQL performance



FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016

SQL Engine



FIX: Assertion error occurs when you run a query to access sys.dm_db_xtp_checkpoint_files in SQL Server 2016

In-Memory OLTP

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 update:

Language support

  • SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.

Components (features) updated

One Cumulative Update package includes all available updates for ALL SQL Server 2016 components (features). However, the cumulative update package updates only those components that are currently installed on the SQL Server instance you select to be serviced.  If a SQL Server feature (e.g. Analysis Services) is added to the instance after this CU is applied, you must re-apply this CU to update the new feature to this CU.

Support for this update

If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and to issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

  1. In Control Panel, select View installed updates under Programs and Features.

  2. Locate the entry that corresponds to this cumulative update package under Microsoft SQL Server 2016.

  3. Press and hold (or right-click) the entry, and then select Uninstall.

Cumulative update package information

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!