Cumulative Update 2 for SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

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


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
7765668 3195888 FIX: High CPU usage causes performance issues in SQL Server 2016 SQL performance
7990674 3178541 PivotTable connects to incorrect data source in SQL Server 2012 or 2014 PowerPivot for SharePoint Analysis Services
8198014 3174476 FIX: Deadlock occurs when you acquire a SCH-M lock and alter a partition in SQL Server 2014 or 2016 SQL service
8197977 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016 SQL service
7990669 3171516 Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Analysis Services
7955222 3183440 Error when you use SecurityFilteringBehavior enumeration in SQL Server 2016 Analysis Services Analysis Services
7855195 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS Reporting Services
8198000 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Integration Services
8001820 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
8260699 3189372 Query returns incorrect results from nonclustered columnstore index under snapshot isolation level in SQL Server 2016 SQL service
7990705 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name SQL service
8197968 3153836 Operating system error 32 when you restore a database in SQL Server 2014 or 2016 SQL service
8275126 3189264 Incorrect results are returned when you execute a query that contains a GROUP BY operation in SQL Server 2016 SQL performance
7990651 3156452 FIX: "'Salt' attribute for OraPassword is missing" error in SSIS in SQL Server 2012 or 2014 Integration Services
8275709 3189060 Standard edition of SQL Server 2016 Analysis Services (Tabular mode) ignores the 16 GB memory limit Analysis Services
7990694 3177666 FIX: Cannot create or manage data alert for a report if the report name or folder name contains a comma in SSRS Reporting Services
8208448 3187654 Update to add support for the Analyze in Excel feature for some regions in Power BI Analysis Services
8273336 3189364 Query Store returns unusual characters when a JOIN operator is used in SQL Server 2016 SQL service
8208393 3192154 A non-optimal query plan choice results in poor performance when values outside the range represented in statistics are searched in SQL Server 2016 SQL performance
7779870 3171505 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain Reporting Services
7855159 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016 Management Tools
7990714 3166545 FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
8037273 3181526 Calculation using two measure time values in iterations returns negative values in SQL Server 2014 or 2016 SQL service
8208296 3187493 FIX: DISCOVER_TABLE_STORAGE_COLUMN_SEGMENTS DMV returns an incorrect result of memory usage in SQL Server 2016 Analysis Services
8255153 3188950 Updating while compression is in progress can lead to nonclustered columnstore index corruption in SQL Server 2016 SQL service
8198030 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
7990660 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
7873772 3184135 Cannot open a Reporting Services report from the SSRS portal when the host computer has FIPS compliance enabled Reporting Services
7855214 3106976 FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016 SQL security
7837980 3174812 FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016 SQL service
7944505 3186433 FIX: Cannot print a Reporting Services report from the SSRS 2016 web portal Reporting Services
8073582 3186435 FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed Reporting Services
8198017 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server High Availability
8075960 3189655 Error 33294 if a cursor is declared by using the OPTION (RECOMPILE) query hint in SQL Server 2016 SQL security
7990723 3170051 FIX: SQL Server failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting High Availability
7855169 3160427 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
8198041 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
7989907 3185650 FIX: Access violation occurs when execute a query that contains many COUNT DISTINCT operations in SQL Server 2016 SQL service
7855191 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016 SQL service
8197974 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Reporting Services
8208458 3192117 An access violation occurs when you execute a query if trace flag 4139 is enabled in SQL Server 2016 SQL performance
8045133 3183721 "The connection string is not valid" error occurs when you use a data source of type Microsoft SharePoint List in SQL Server 2016 Reporting Services Reporting Services
7855179 3162589 FIX: High CPU usage on SQL queries after you install SQL Server SQL service
8197987 3165168 Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server SQL service
8086115 3188978 FIX: "Cannot bulk load" error when you run a query that contains an UPDATE statement in SQL Server 2016 SQL performance
7855184 3168709 SQL Server 2014 or 2012 doesn't start after you configure the tempdb database to use a very small log file SQL service
7779870 3171505 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain Reporting Services
7855174 3161119 FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 or 2016 SQL service
8197990 3179596 "Failed Assertion = 'm_pExclusiveOwner != pWorker'" is continuously logged in the SQL Server 2014 or 2016 error log SQL service
7990660 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
8268335 3189276 Adds the support to audit the information that's collected by the SQL Server Usage Feedback Collection SQL service
7990720 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
8258545 3188368 FIX: Access violation on secondary replica when there are too many parallel redo operations in SQL Server 2016 High Availability
8258377 3191515 Cannot filter the mobile report correctly when the parameter contains special characters in SQL Server 2016 Reporting Services Reporting Services
8357071 3192687 The rxExec function does not run the rxDataStep function in parallel on Windows operating systems SQL service
8208291 3187549 FIX: Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services Analysis Services
8204190 3192636 Data grid becomes blank when you scroll if the "Row numbers" option is set to Hide in a SQL Server 2016 Reporting Services mobile report Reporting Services
8198027 3178526 An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 or 2016 SQL connectivity
8058912 3182868 FIX: Queries that contain recursive CROSS APPLY operations run slowly in SQL Server 2016 SQL security
7762097 3189055 IntelliSense feature displays incomplete or incorrect information for the AMO library Analysis Services
8048420 3188980 FIX: Duplicate mobile reports and KPIs are displayed in Power BI Mobile app Reporting Services
8291010 3184227 "The remote server '(null)' does not exist" error occurs after you remove an article from a publication in SQL Server SQL service
7855176 3154482 FIX: Service Broker UCS task leaks memory in SQL Server 2014 or 2016 SQL service
8197993 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan SQL performance
8198024 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
  3170123 Supports DROP TABLE DDL for articles that are included in transactional replication in SQL Server 2014 or in SQL Server 2016 SQL service
7504584 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR in SQL Server 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:

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.