Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

KB5000645 - Cumulative Update 16 for SQL Server 2016 SP2

  • Applies to: SQL Server 2016 Developer, SQL Server 2016 Enterprise, SQL Server 2016 Enterprise Core, SQL Server 2016 Express, SQL Server 2016 Standard, SQL Server 2016 Business Intelligence, SQL Server 2016 Web

Release Date:   February 11, 2021
Version:   13.0.5882.1

Note

After you apply CU 16 for SQL Server 2016 SP2, you might encounter an issue in which DML (insert/update/delete) queries that use parallel plans cannot complete any execution and encounter `HP_SPOOL_BARRIER`` waits. You can use the trace flag 13116 or MAXDOP=1 hint to work around this issue. This issue is related to the introduction of fix for 13685819 and it will be fixed in the next Cumulative Update.

This article describes Cumulative Update package 16 (CU16) (build number: 13.0.5882.1) 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.

Improvements and fixes included in this update

Bug reference Description Fix area Platform
13740271 FIX: Wrong results due to undetected concatenation parameters from scalar expression (KB5000649) SQL performance All
13910344 FIX: Assert failure occurs when concurrent query modifies the same bitmap during clustered columnstore delete bitmap seek in SQL Server 2016 (KB5000651) SQL Engine All
13684505 Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is a AG failover undergoing. High Availability All
13790726 Improves the records stage of failure and error during stack copy for better diagnostics. SQL Engine All
13911648 FIX: Prevents error 9029 from being reported on AlwaysOn Availability Database during recovery after transition to SECONDARY role, which results in database being in Not Synchronizing/ In Recovery state. This can only occur if the database is configured to use Persistent Log Buffer for transaction log. SQL Engine All
13872394 VC++ 2015 Redistributable installation returns error 1638 when newer version already installed (KB4092997) SQL Engine Windows
13714938 FIX: User session is in rollback state indefinitely after it is killed in SQL Server 2016 and 2019 (KB4585971) SQL Engine Windows
13664250 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server (KB4589350) SQL performance Windows
13755880 FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 (KB5000650) In-memory OLTP Windows
13883014 FIX: Non-yielding condition occurs when you execute a query in batch mode in SQL Server 2016 (KB5000652) SQL Engine Windows
13849761 FIX: Failures with log reader agent occurs when you create and drop publication on CDC enabled database in SQL Server 2016 (KB5000715) SQL Engine Windows
13773660 FIX: Error when you enable managed or automated backup in SQL Server 2016 and 2017 if "Allow Blob Public Access" is disabled on a storage account (KB4589360) SQL Engine Windows
13685819 Fixes an issue with insert query in SQL Server 2016 that reads the data from the same table and uses a parallel execution plan may produce duplicate rows. SQL performance Windows
13720644 Fixes an Access Violation error that occurs at sqllang!CStatement::SetDbIdMaskingUsageInfo+0x11 in SQL Server 2016. SQL security Windows
13746920 Unable to connect to primary database replica after failing over the Availability Group in SQL Server. High Availability Windows
13760750 Forwarder is unable to reconnect to global primary following Global primary planned failover if the LISTENER_URL is modified. High Availability Windows
13786217 Fixes the replication issues that occur with Log Reader Agent and xp_sqlagent_notify after AG Failover. SQL Engine Windows
13819009 Fixes FullText query not returning the expected values that are located on the FullText index structure with AccentSensitivity turned on. SQL Engine Windows
13866749 Fixes Access violation exception that occurs when queries are executed in read uncommitted mode with high concurrent read or write pattern over XML data types. SQL Engine Windows
13878424 Fixes Performance issue that occurs with CHANGETABLE function and syscommit on SQL Server 2016. SQL performance Windows
13578477 Fixes the foreign key referencing unique index with included columns which causes replication to fail. SQL Engine Windows
13883910 Fixes the Access Violation error that occurs when importing large amount of data to Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction. SQL Engine Windows
13905138 Fixes the error that occurs when a change tracking function in MSTVF is called in SQL Server 2016.

Msg 443, Level 16, State 1, Procedure <ProcedureName>, Line <LineNumber> [Batch Start Line <LineNumber>]
Invalid use of a side-effecting operator 'change_tracking_current_version' within a function		 SQL Engine Windows

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:

👁 Image
Download the latest cumulative update package for SQL Server 2016 SP2 now

If the download page doesn't 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 install the latest cumulative update available.

Notes for this update

Cumulative update package information

File information

References

Feedback

Was this page helpful?

Additional resources

  • Last updated on