Cumulative Update 2 for SQL Server 2016 SP1

Applies to: Microsoft SQL Server 2016 Service Pack 1

This article describes cumulative update package 2 (build number: 13.0.4422.0) for Microsoft SQL Server 2016 Service Pack 1 (SP1) . This update contains fixes that were released after the release of SQL Server 2016 SP1.

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

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
9237302 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
9237399 3205994 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 SQL service
9367828 3213240 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption SQL service
9367877 3211602 FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016 SQL performance
9237319 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
9367894 3180980 Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected Reporting Services
9367882 3204265 FIX: Image maps not rendered as expected in SSRS custom report item Reporting Services
9367937 3213288 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group High Availability
9379508 4013116 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements do not detect a duplicate key in SQL Server 2016 In-Memory OLTP
9367822 3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015 Reporting Services
9514259 4013936 FIX: Hadoop File System Task fails after 10 minutes when you open and run a saved SSIS 2016 package Integration Services
9061115 3210708 FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates SQL service
9367895 3188454 Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server SQL service
9367929 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2016 SQL performance
9330686 4010984 FIX: Assertion error when dm_exec_query_statistics_xml is used in a query plan that contains certain operators in SQL Server 2016 SQL performance
9503252 4009839 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode Analysis Services
9069693 3195752 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016 SQL service
9367885 3194959 Statistics are removed after rebuilding a specific partition of an partitioned aligned index on a partitioned table in SQL Server SQL performance
9287975 4014013 FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 Analysis Services
9237364 3208179 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services Analysis Services
9237403 3207327 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server High Availability
9367888 3195825 FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016 SQL performance
9367901 3198826 FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services Analysis Services
9367921 3212789 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 SQL service
9367933 3211338 FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016 SQL service
9452905 4013119 FIX: DBCC CLONEDATABASE doesn't copy the runtime cache of the query store to the clone in SQL Server 2016 SP1 SQL service
9456824 4013122 Improvement: Performance improvement for the "sequence point algorithm" step in an SSAS 2016 Tabular Model transaction Analysis Services
9389933 4013248 FIX: User authentication failure in SSRS 2016 under the custom security extensions deployment Reporting Services
9503259 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
9237395 3204469 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication SQL service
9237369 3196012 FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server SQL service
9439184 3182545 SQL Server 2016 Service Pack 1 release information/a> Master Data Services (MDS)
9193209 4013883 FIX: Data type conversion error in a query that involves a column store index in SQL Server 2016 SQL service
9237347 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
9237384 3189959 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment High Availability
9367873 3205411 FIX: "Non-yielding Scheduler" condition when you parallel-load data into a columnstore index in SQL Server 2016 SQL service
9367887 3184099 SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
9367898 3194365 FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking SQL performance
9367920 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server SQL service
9371007 4013112 FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016 SQL service
9473330 4013125 Update improves DMV sys.dm_os_sys_info and sys.dm_os_sys_info in SQL Server 2016 SQL service
9237407 3208243 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 SQL service
9367931 3212523 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory SQL service
9367862 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
9468558 4013207 https://support.microsoft.com/en-us/help/4013207?preview  
9403683 5852300 FIX: "Incorrect syntax for definition of the 'default' constraint" error when you add an arbitrary columnstore column in SQL Server 2016 SQL service
9324510 4013851 FIX: Error when you add a NOT NULL column with default values to a non-empty clustered columnstore index in SQL Server 2016 Standard and Express edition SQL service
9503270 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
9367903 3197950 FIX: Error when you open Data Alert Manager in SQL Server 2014 or 2016 Reporting Services in SharePoint integrated mode Reporting Services
9368268 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS Reporting Services
9237390 3204769 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 SQL service
9367814 3192692 FIX: Assert memory dump on a mirror server in SQL Server High Availability
9367891 3115741 FIX:"The process cannot access the file" error when an XML task fails in SQL Server Integration Services
9395865 3186435 FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed Management Tools
9367872 3198356 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services Analysis Services
9367911 3211605 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode Analysis Services
9368264 3211304 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 High Availability
9237401 3206299 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 AlwaysOn availability group High Availability
9367429 3197883 FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication Management Tools
9367867 3197879 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent Management Tools
9230882 3216543 FIX: More CPU consumption when many consecutive transactions insert data into a temp table in SQL Server 2016 than in SQL Server 2014 SQL performance
9125813 4013110 FIX: SSRS 2016 mobile report that contains a shared dataset times out and does not load Reporting Services
9379510 4013115 FIX: CREATE OR ALTER statement applied on a DDL trigger fails on the next execution in SQL Server 2016 SQL service
9452934 4013120 Improvement: Enable DBCC CLONEDATABASE to clone a full-text object in SQL Server 2016 SP1 SQL service
9398927 4014862 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2016 Reporting Services
9452932 4014002 Improvement: Enable SQL Server Managed Backup to back up databases that are larger than 50 GB to Microsoft Azure in SQL Server 2016 SQL service
9367879 3202425 Improvement: Improves the query performance for SQL Server 2016 by changing the use of histograms on UNIQUE columns SQL performance
9398869 4013118 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 SQL service
9237313 3067968 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 SQL service
9367818 3212193 FIX: Cannot save the SSRS report after you change a parameter in Report Builder or the SQL Server Data Tool Reporting Services
9367868 3212916 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string Analysis Services
9367909 3212482 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 SQL service
9237405 3209459 FIX: Error 21050 when you remove a table that is not part of a publication in SQL Server 2014 or 2016 SQL service
9237354 3209442 FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server 2014 or 2016 MDM report Management Tools
9367892 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server High Availability
9367910 3201416 FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 or 2016 SQL service
9367925 3209520 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly Analysis Services
9367939 3213283 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 SQL service
9467732 4013206 FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance Analysis Services
9503261 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Management Tools
9269601 3210089 GDR update package for SQL Server 2016 SP1 Reporting Services
9237417 3208246 Updates to DBCC CLONEDATABASE functionality in SQL Server 2014 and 2016 SQL service
9503182 3208276 Update improves handling of documents too large for Full-Text Search indexing in SQL Server 2014 or 2016 SQL service
9619420 4013999 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 SQL service
9460219 4013124 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 In-Memory OLTP
9237342 3208245 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 SQL performance
9503255 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database SQL service
9367922 3213263 FIX: Error when creating a stored procedure that uses a synonym together with an index hint in SQL Server 2016 SQL service
9234045 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
9368268 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS/a> Reporting Services
9237409 3208524 FIX: You cannot select any replica when you fail over from an availability group that's in the resolving state High Availability
9503250 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
9503272 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Setup & Install
9491976 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
9503266 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure SQL service
9367917 3177238 FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server High Availability
9367897 3197631 FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server SQL security
9367923 3210597 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 SQL service
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 SQL service
8845976   A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
9379260 4016657 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 High Availability
8861790 3206584 FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables 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 hotfixes:

Cumulative update package information


Prerequisites

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

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.