Cumulative Update 5 for SQL Server 2016

Applies to: SQL Server 2016
This article describes cumulative update package 5 (build number: 13.0.2197.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 Microsoft 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.

Known Issue

After installing this CU, Change Data Capture (CDC) functionality might break if :

  • The databases enabled for CDC are part of Always On availability group (or)
  • SQL Server replication components are not installed on the server

For more information, see:

Hotfixes that are included in this cumulative update package

VSTS bug number KB article number Description Fix area Status
9077598 3211948 FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage Reporting Services
9367817 3212193 FIX: Cannot save the SSRS report after you change a parameter in Report Builder or the SQL Server Data Tool Reporting Services
9503251 4009839 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode Analysis Services
8463442 3195752 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016  
9237404 3209459 FIX: Error 21050 when you remove a table that is not part of a publication in SQL Server 2014 or 2016 SQL service
9237351 3209442 FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server 2014 or 2016 MDM report Management Tools
8532466 4009794 FIX: Internal error 'FAC_HK_INTERNAL' when you insert or update large numbers of rows of data into or in a memory-optimized table in SQL Server 2016 In-Memory OLTP
9237398 3205994 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 SQL service
9367827 3213240 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption SQL service
9231234 3208460 FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 CU5 SQL service
9398962 4013118 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 SQL service
9237312 3067968 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 SQL service
8652609 3198751 FIX: Out-of-memory error when you run a query to access LOB columns through In-Memory OLTP in SQL Server 2016 In-Memory OLTP
9503260 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Management Tools
9503181 3208276 Update improves handling of documents too large for Full-Text Search indexing in SQL Server 2014 or 2016 SQL service
9460252 4013124 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 In-Memory OLTP
9237340 3208245 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 SQL performance
9367388 4014719 FIX: "(0x80004002) No such interface supported" error when you use RMO to run Web Synchronization for Merge Replication in SQL Server 2016 SQL service
9237386 3192069 FIX: Resize handle is missing from the parameter combo box in SQL Server 2014 or 2016 Reporting Services Reporting Services
8930551 4013877 Update enables DML query plan to scan query memory-optimized tables in parallel in SQL Server 2016 In-Memory OLTP
8845976 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
8497323 3204469 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication SQL service
9503253 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database SQL service
9503265 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure SQL service
9367821 3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015 Reporting Services
9237408 3208524 FIX: You cannot select any replica when you fail over from an availability group that's in the resolving state High Availability
9503249 4009823 FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 and 2016 SQL performance
9491987 4014734 FIX: SQL Server Launchpad service fails to start if the installed version of R Services (In-Database) is different from the Database Engine in SQL Server 2016 SQL service
9237381 3189959 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment High Availability
9237406 3208243 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 SQL service
9367861 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
9503269 4010710 FIX: Memory leak when you run a query that you don’t have sufficient permissions for in SQL Server 2014 or 2016 SQL security
9237301 3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database SQL service
9237363 3208179 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services Analysis Services
9237402 3207327 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server High Availability
9379517 4013116 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements do not detect a duplicate key in SQL Server 2016 In-Memory OLTP
9367384 3213703 FIX: An Always On secondary replica goes into a disconnecting state High Availability
9503258 4010344 FIX: The sp_msx_enlist stored procedure fails to enlist a target server into a master server in SQL Server 2014 or 2016 if the server name is too long Management Tools
9237345 3205935 FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 or 2016 SQL performance
9367813 3192692 FIX: Assert memory dump on a mirror server in SQL Server High Availability
9371141 4013112 FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016  
9368262 3211304 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 High Availability
9237316 3196877 FIX: Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 or 2016 SQL performance
9237400 3206299 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 AlwaysOn availability group High Availability
9368267 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS Reporting Services
9237389 3204769 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 SQL services
9503271 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Setup & Install
9379254 4016655 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 Setup & Install

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 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.

References