SQL Server 2016 articles, fixes and updates - January 2021

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2016 that have been released in January 2021. The list is daily updated.

• 5852300 FIX: SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE command Q5852300 KB5852300 January 26, 2021
• 4564903 Cumulative Update 14 for SQL Server 2016 SP2 Q4564903 KB4564903 January 26, 2021
• 4536648 Cumulative Update 12 for SQL Server 2016 SP2 Q4536648 KB4536648 January 26, 2021
• 4527378 Cumulative Update 11 for SQL Server 2016 SP2 Q4527378 KB4527378 January 26, 2021
• 4524334 Cumulative Update 10 for SQL Server 2016 SP2 Q4524334 KB4524334 January 26, 2021
• 4505830 Cumulative Update 8 for SQL Server 2016 SP2 Q4505830 KB4505830 January 26, 2021
• 4488535 Cumulative Update 14 for SQL Server 2016 SP1 Q4488535 KB4488535 January 26, 2021
• 4481148 FIX: Restore or Restore Verifyonly of a TDE-compressed backup fails with error 33111 and 3013 in SQL Server 2016 and 2017 Q4481148 KB4481148 January 26, 2021
• 4480653 FIX: Error occurs when you run a query that includes a Boolean field against PolyBase external tables in SQL Server 2016 and 2017 Q4480653 KB4480653 January 26, 2021
• 4476977 FIX: Error 5901 occurs on the same offset in SQL Server 2016 until server is restarted Q4476977 KB4476977 January 26, 2021
• 4476949 FIX: Database Mail cannot send emails after you install CU1, CU2 or CU3 for SQL Server 2016 Service Pack 2 Q4476949 KB4476949 January 26, 2021
• 4475794 FIX: Access violation exception occurs during Query Optimization of a query that accesses a table with Filtered Indexes or Statistics Q4475794 KB4475794 January 26, 2021
• 4475775 Cumulative Update 13 for SQL Server 2016 SP1 Q4475775 KB4475775 January 26, 2021
• 4475322 FIX: "Non-yielding" error occurs when there is a heavy use of prepared statements in SQL Server 2014, 2016 and 2017 Q4475322 KB4475322 January 26, 2021
• 4470916 FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2 percent in SQL Server 2014 and 2016 Q4470916 KB4470916 January 26, 2021
• 4469554 FIX: Assertion error occurs during restore of compressed backups in SQL Server 2014, 2016 and 2017 Q4469554 KB4469554 January 26, 2021
• 4468103 FIX: Access violation occurs in Distribution Agent in SQL Server 2016 and 2017 Q4468103 KB4468103 January 26, 2021
• 4465745 FIX: Assertion error occurs when you run a MERGE statement with an OUTPUT clause in SQL Server 2016 and 2017 Q4465745 KB4465745 January 26, 2021
• 4464343 Cumulative Update 12 for SQL Server 2016 SP1 Q4464343 KB4464343 January 26, 2021
• 4461562 FIX: Transactions and log truncation may be blocked when you use Query Store in SQL Server 2016 and 2017 Q4461562 KB4461562 January 26, 2021
• 4460112 FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017 Q4460112 KB4460112 January 26, 2021
• 4459709 FIX: Poor performance occurs when you run a query against columnstore in an RCSI-enabled database in SQL Server 2016 and 2017 Q4459709 KB4459709 January 26, 2021
• 4459545 FIX: Upgrading SP1 instance fails when you use SxS instances of SQL Server 2016 SP1 and SP2 Q4459545 KB4459545 January 26, 2021
• 4457953 FIX: Access violations and unhandled exceptions when you set automatic seeding for secondary replica or Distributed Availability Group replica in SQL Server Q4457953 KB4457953 January 26, 2021
• 4346803 FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server Q4346803 KB4346803 January 26, 2021
• 4341398 FIX: Event notifications for AUDIT_LOGIN and AUDIT_LOGIN_FAILED events will cause an unusual growth of TempDB in SQL Server 2016 and 2017 Q4341398 KB4341398 January 26, 2021
• 4340759 FIX: Slow performance of SQL Server 2016 when Query Store is enabled Q4340759 KB4340759 January 26, 2021
• 4340746 FIX: No records are returned when you run an MDX query after restarting SSAS 2016 and 2017 Q4340746 KB4340746 January 26, 2021
• 4339447 FIX: SSAS crashes when Process Full mode is executed after Process Clear in SQL Server 2016 Q4339447 KB4339447 January 26, 2021
• 4338890 FIX: "Non-yielding Scheduler" error and SQL Server appears unresponsive in SQL Server 2014, 2016 and 2017 Q4338890 KB4338890 January 26, 2021
• 4338761 FIX: SQL Server may generate EXCEPTION_ACCESS_VIOLATION dump file when you merge two partitions of system-versioned temporal tables in SQL Server 2016 or 2017 Q4338761 KB4338761 January 26, 2021
• 4338715 FIX: Many xml_deadlock_report events are reported for one single intra-query deadlock occurrence in SQL Server 2016 and 2017 Q4338715 KB4338715 January 26, 2021
• 4338040 FIX: Rectangle does not grow vertically together with internal Textbox in the report in SSRS 2016 when you set rc:Toolbar=False Q4338040 KB4338040 January 26, 2021
• 4099472 PFS page round robin algorithm improvement in SQL Server 2014, 2016 and 2017 Q4099472 KB4099472 January 26, 2021
• 4092069 Improves the Distribution Agent cleanup procedure to increase the transactional replication performance in SQL Server 2016 Q4092069 KB4092069 January 26, 2021
• 4092045 FIX: LSN truncation occurs in AlwaysOn AG when disabling the change data capture feature in SQL Server 2016 Q4092045 KB4092045 January 26, 2021
• 4091245 FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 Q4091245 KB4091245 January 26, 2021
• 4090966 SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016 Q4090966 KB4090966 January 26, 2021
• 4090486 FIX: Managed Backup fails when database is renamed with trailing white space in SQL Server 2016 and 2017 Q4090486 KB4090486 January 26, 2021
• 4090279 FIX: It takes a long time to roll back a batch that updates a large amount of data in SQL Server 2016 Q4090279 KB4090279 January 26, 2021
• 4090032 FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode Q4090032 KB4090032 January 26, 2021
• 4089950 Update to support partition elimination in query plans that have spatial indexes in SQL Server 2016 and 2017 Q4089950 KB4089950 January 26, 2021
• 4089948 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2016 or 2017 Q4089948 KB4089948 January 26, 2021
• 4089819 FIX: "A time-out occurred while waiting for buffer latch -- type 4" error when you use Availability Groups in SQL Server 2016 or 2017 Q4089819 KB4089819 January 26, 2021
• 4089623 FIX: Out of memory occurs and query fails when you run MDX query with NON EMPTY option in SSAS Q4089623 KB4089623 January 26, 2021
• 4089473 Better intra-query parallelism deadlocks troubleshooting in SQL Server 2017 and 2016 Q4089473 KB4089473 January 26, 2021
• 4089324 FIX: Error 15665 when you call sp_set_session_context repeatedly with null key value in SQL Server 2016 and 2017 Q4089324 KB4089324 January 26, 2021
• 4089239 FIX: QRY_PROFILE_LIST_MUTEX is blocked when TF 7412 is enabled in SQL Server 2016 and 2017 Q4089239 KB4089239 January 26, 2021
• 4088193 FIX: Slow restore performance when restoring a compressed backup on a disk with 4K sector size in SQL Server Q4088193 KB4088193 January 26, 2021
• 4087358 FIX: Expression-based connection string is cleared out when you configure data sources for the report in SSRS 2016 Q4087358 KB4087358 January 26, 2021
• 4086136 FIX: SSAS stops responding when you run an MDX query in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) Q4086136 KB4086136 January 26, 2021
• 4083949 FIX: SSAS may crash when you run a DAX query by using a non-admin Windows user in SQL Server 2016 and 2017 Q4083949 KB4083949 January 26, 2021
• 4078596 FIX: Random access violations occur when you run monitoring stored procedure in SQL Server 2016 and 2017 Q4078596 KB4078596 January 26, 2021
• 4077105 FIX: Out of memory error when the virtual address space of the SQL Server process is very low in SQL Server Q4077105 KB4077105 January 26, 2021
• 4058747 FIX: Error when upgrading SSIS catalog database in SQL Server 2016 and 2017 Standard Edition Q4058747 KB4058747 January 26, 2021
• 4058289 FIX: ALTER PROCEDURE WITH ENCRYPTION statement fails when you encrypt a non-published stored procedure in SQL Server 2016 and 2017 Q4058289 KB4058289 January 26, 2021
• 4058175 FIX: TDE-enabled backup and restore are slow if the encryption key is stored in an EKM provider in SQL Server Q4058175 KB4058175 January 26, 2021
• 4058174 FIX: Heavy tempdb contention occurs in SQL Server 2016 or 2017 Q4058174 KB4058174 January 26, 2021
• 4057759 FIX: Internal error when you drill down hierarchy members in SSAS 2016 and 2017 in multidimensional mode Q4057759 KB4057759 January 26, 2021
• 4057615 FIX: "Incorrect syntax near the keyword 'KEY'" error when you add an Oracle table with primary column named 'KEY' in SQL Server 2016 and 2017 Q4057615 KB4057615 January 26, 2021
• 4057212 FIX: Memory leak occurs when you back up a database that contains memory-optimized objects in SQL Server 2016 Q4057212 KB4057212 January 26, 2021
• 4057190 FIX: Error 14684 when you reconfigure Management Data Warehouse in a named instance of SQL Server 2016 and 2017 Q4057190 KB4057190 January 26, 2021
• 4057119 Cumulative Update 7 for SQL Server 2016 SP1 Q4057119 KB4057119 January 26, 2021
• 4057055 FIX: A deadlock occurs when you run a parallel query on a clustered columnstore index in SQL Server 2016 and 2017 Q4057055 KB4057055 January 26, 2021
• 4057054 FIX: CXPACKET and CXCONSUMER wait types show inconsistent results for some parallel query plans in SQL Server 2016 and 2017 Q4057054 KB4057054 January 26, 2021
• 4056831 FIX: Error 27231 occurs when SSIS package that contains localized language is deployed in SQL Server 2016 Q4056831 KB4056831 January 26, 2021
• 4056821 FIX: Log shipping fails when you use it together with Always On Availability Groups in SQL Server 2016 and 2017 Q4056821 KB4056821 January 26, 2021
• 4056117 FIX: Assertion occurs when you pass memory-optimized table variable into a stored procedure as table-valued parameter in SQL Server 2016 and 2017 Q4056117 KB4056117 January 26, 2021
• 4056008 FIX: "sp_special_columns" returns incorrect result in SQL Server 2014 and 2016 Q4056008 KB4056008 January 26, 2021
• 4055758 FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server Q4055758 KB4055758 January 26, 2021
• 4055735 FIX: DBCC CHECKDB returns consistency errors if SOUNDEX function is used in PERSISTED computed columns in SQL Server Q4055735 KB4055735 January 26, 2021
• 4055727 FIX: Recovery of database takes a long time when it contains memory-optimized tables in SQL Server 2016 and 2017 Q4055727 KB4055727 January 26, 2021
• 4055674 FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services Q4055674 KB4055674 January 26, 2021
• 4055556 FIX: Error when you rebuild a single partition of an index online in SQL Server 2014 and 2016 Q4055556 KB4055556 January 26, 2021
• 4055456 FIX: "Incompletely installed" error on Feature Selection page when you modify the current installation of SQL Server 2016 SP1 or SQL Server 2016 SP1 CU5 Q4055456 KB4055456 January 26, 2021
• 4055281 FIX: "Msg 3948" error when you run a query on secondary replica of secondary availability group in SQL Server 2016 and 2017 Q4055281 KB4055281 January 26, 2021
• 4054842 Improvement: General improvements to the change tracking cleanup process in SQL Server 2016 and 2017 Q4054842 KB4054842 January 26, 2021
• 4054398 FIX: "Invalid comparison due to NO COLLATION" retail assert occurs in SQL Server 2014, 2016, and 2017 Q4054398 KB4054398 January 26, 2021
• 4053550 FIX: Processing XML message through Service Broker results in hung session in SQL Server 2016 and 2017 Q4053550 KB4053550 January 26, 2021
• 4052138 FIX: Parallel queries are slower when they are run with high DOP in SQL Server 2016 Q4052138 KB4052138 January 26, 2021
• 4052137 Improve query performance on a partitioned table in SQL Server 2016 SP2 Q4052137 KB4052137 January 26, 2021
• 4052131 FIX: DMV sys.dm_os_windows_info returns wrong values for Windows 10 and Windows Server 2016 Q4052131 KB4052131 January 26, 2021
• 4052129 Update for manual change tracking cleanup procedure in SQL Server 2014, 2016 and 2017 Q4052129 KB4052129 January 26, 2021
• 4052125 FIX: Audit Log for ROLLBACK TRANSACTION event is not available in SQL Server 2016 Q4052125 KB4052125 January 26, 2021
• 4052123 FIX: Sliding expiration for authentication cookie isn't working and fails to redirect to logon page in SSRS 2016 and 2017 Q4052123 KB4052123 January 26, 2021
• 4052119 FIX: New Distributed Transactions in an AG database fails after you restart DTC service in SQL Server 2016 Q4052119 KB4052119 January 26, 2021
• 4051361 Optimizer row goal information in query execution plan added in SQL Server 2014, 2016 and 2017 Q4051361 KB4051361 January 26, 2021
• 4051360 FIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2 Q4051360 KB4051360 January 26, 2021
• 4051358 Update adds new columns to sys.dm_exec_query_stats DMV in SQL Server 2016 SP2 Q4051358 KB4051358 January 26, 2021
• 4051356 FIX: In-memory database restore fails with errors in SQL Server 2016 and SQL Server 2017 Q4051356 KB4051356 January 26, 2021
• 4049027 FIX: "AdomdConnectionException" error when SSRS 2016 and 2017 data source uses msmdpump.dll Q4049027 KB4049027 January 26, 2021
• 4048967 FIX: Can't enable or disable change data capture for a database after you attach it in SQL Server 2014, 2016, or 2017 Q4048967 KB4048967 January 26, 2021
• 4048943 FIX: Access violation occurs on primary replica of AlwaysOn Availability Group in SQL Server Q4048943 KB4048943 January 26, 2021
• 4048942 FIX: Memory dumps generated for "Stalled IOCP Listener" and "non-yielding IOCP listener" after SQL Server restart Q4048942 KB4048942 January 26, 2021
• 4046914 FIX: Add CXPACKET wait type in showplan XML in SQL Server 2016 and 2017 Q4046914 KB4046914 January 26, 2021
• 4046909 FIX: LogPool cache MEMORYCLERK_SQLLOGPOOL consumes more memory when you do online transactions in SQL Server 2016 SP1 Express Edition Q4046909 KB4046909 January 26, 2021
• 4046745 FIX: UPDATE statement fails silently when you reference a nonexistent partition function in the WHERE clause in SQL Server 2014, 2016, or 2017 Q4046745 KB4046745 January 26, 2021
• 4044064 FIX: "Request timed out" error when you change security options for an MDS security group in SQL Server 2016 and 2017 Q4044064 KB4044064 January 26, 2021
• 4043947 FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS Q4043947 KB4043947 January 26, 2021
• 4042788 FIX: The tempdb system database is still encrypted after you turn off encryption on an instance of SQL Server Q4042788 KB4042788 January 26, 2021
• 4042415 FIX: Deadlock occurs on single-user mode database when many connections access it simultaneously in SQL Server 2014 and 2016 Q4042415 KB4042415 January 26, 2021
• 4042232 FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server Q4042232 KB4042232 January 26, 2021
• 4041814 Improve tempdb spill diagnostics in DMV and Extended Events in SQL Server 2017 and SQL Server 2016 SP2 Q4041814 KB4041814 January 26, 2021
• 4041811 FIX: Automatic update of incremental statistics is delayed in SQL Server 2014, 2016 and 2017 Q4041811 KB4041811 January 26, 2021
• 4041809 Update adds support for MAXDOP option for CREATE STATISTICS and UPDATE STATISTICS statements in SQL Server 2014, 2016 and 2017 Q4041809 KB4041809 January 26, 2021
• 4040510 FIX: A dump file is generated when you run a sp_execute_external_script statement in parallel mode in SQL Server 2016 Q4040510 KB4040510 January 26, 2021
• 4038881 FIX: Unexpected exception occurs when you process dimensions by using Process Update in SSAS 2016 or SSAS 2017 Q4038881 KB4038881 January 26, 2021
• 4038419 Update adds CPU timeout setting to Resource Governor workgroup REQUEST_MAX_CPU_TIME_SEC in SQL Server 2014, 2016 and 2017 Q4038419 KB4038419 January 26, 2021
• 4038418 Update adds a new column to DMV sys.dm_sql_referenced_entities in SQL Server 2014 and 2016 Q4038418 KB4038418 January 26, 2021
• 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed Q4038210 KB4038210 January 26, 2021
• 4037454 FIX: Policy-Based Management policy isn't working after you install CU2 for SQL Server 2016 SP1 Q4037454 KB4037454 January 26, 2021
• 4037435 FIX: Access violation occurs when you query the sys.availability_groups catalog view in SQL Server 2016 Q4037435 KB4037435 January 26, 2021
• 4037412 FIX: Error when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID Q4037412 KB4037412 January 26, 2021
• 4037357 Cumulative Update 9 for SQL Server 2016 Q4037357 KB4037357 January 26, 2021
• 4034056 FIX: Access violation occurs when you run a query in SQL Server 2016 Q4034056 KB4034056 January 26, 2021
• 4033178 FIX: Cast error when you open a local mode report in SharePoint Integrated mode in SSRS 2016 Q4033178 KB4033178 January 26, 2021
• 4032686 FIX: Search result isn't highlighted in SSRS 2016 report in SharePoint integrated mode Q4032686 KB4032686 January 26, 2021
• 4032200 FIX: Fail to compress the backup file when INIT and COMPRESSION option is used in a TDE enabled database in SQL Server 2016 Q4032200 KB4032200 January 26, 2021
• 4025261 FIX: The setting for deadlock priority doesn't work when you run the ALTER PARTITION FUNCTION statement in SQL Server 2016 Q4025261 KB4025261 January 26, 2021
• 4025208 FIX: Memory leak occurs when you use memory-optimized tables in Microsoft SQL Server 2016 Standard edition Q4025208 KB4025208 January 26, 2021
• 4024715 FIX: SharePoint sites that contain the Report Viewer Web Part fail to load after you upgrade from SharePoint 2013 to 2016 in SSRS 2016 Q4024715 KB4024715 January 26, 2021
• 4024548 FIX: It takes a long time to perform lots of write operations on SSAS databases in SQL Server 2016 Q4024548 KB4024548 January 26, 2021
• 4024449 FIX: Databases on secondary replica show "NOT SYNCHRONIZING" status after failover in SQL Server 2016 Q4024449 KB4024449 January 26, 2021
• 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 or 2016 Q4024311 KB4024311 January 26, 2021
• 4024304 Cumulative Update 7 for SQL Server 2016 Q4024304 KB4024304 January 26, 2021
• 4023419 FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it's compared to SQL Server 2008 R2 Q4023419 KB4023419 January 26, 2021
• 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 or 2016 Q4022935 KB4022935 January 26, 2021
• 4022873 FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 or 2016 in Windows 10 Creators Update Q4022873 KB4022873 January 26, 2021
• 4021243 FIX: Access violation when you create or configure an Always On availability group for an availability database in SQL Server 2012 and 2016 Q4021243 KB4021243 January 26, 2021
• 4019917 Improvement: Improves the performance in opening a mobile report that contains a large dataset in SSRS 2016 Q4019917 KB4019917 January 26, 2021
• 4019914 Cumulative Update 6 for SQL Server 2016 Q4019914 KB4019914 January 26, 2021
• 4019903 FIX: Query against sys.dm_db_partition_stats DMV runs slow if the database contains large numbers of columnstore partitions in SQL Server 2016 Q4019903 KB4019903 January 26, 2021
• 4019893 FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016 Q4019893 KB4019893 January 26, 2021
• 4019803 FIX: KPIs appear in a random order when you add KPIs to the Favorites page in SSRS 2016 web portal Q4019803 KB4019803 January 26, 2021
• 4019718 FIX: Intra-query deadlock when you execute a parallel query that contains outer join operators in SQL Server 2016 Q4019718 KB4019718 January 26, 2021
• 4019511 FIX: SSAS 2016 fails to start if the MemoryHeapType and HeapTypeForObjects properties are set to "-1" Q4019511 KB4019511 January 26, 2021
• 4019445 FIX: Pie chart legend doesn't format percentage values properly in a SSRS 2016 mobile report Q4019445 KB4019445 January 26, 2021
• 4019285 FIX: Error when you execute DBCC CLONEDATABASE on an "Always Encrypted" enabled database in SQL Server 2014 or 2016 Q4019285 KB4019285 January 26, 2021
• 4019028 FIX: SQL Server 2016 consumes more memory when you reorganize a columnstore index Q4019028 KB4019028 January 26, 2021
• 4018955 FIX: Error when you process a calculated column on a database with compatibility level 1200 in SSAS 2016 tabular mode Q4018955 KB4018955 January 26, 2021
• 4018954 FIX: Domain entity drop-down displays an incorrect value when you connect to MDS by using MDS Add-in for Excel in SQL Server 2016 Q4018954 KB4018954 January 26, 2021
• 4018930 Update adds the "CLR strict security" feature to SQL Server Q4018930 KB4018930 January 26, 2021
• 4018882 FIX: Mobile report does not display correct formatting when regional setting is set to Non-English in SSRS 2016 Q4018882 KB4018882 January 26, 2021
• 4018866 FIX: Parallel redo causes high memory usage in SQL Server 2016 when it's compared to SQL Server 2014 or earlier versions Q4018866 KB4018866 January 26, 2021
• 4017737 FIX: MDS entity sync fails if the Name or Code attribute contains non-default values in SQL Server 2016 Q4017737 KB4017737 January 26, 2021
• 4017445 FIX: A REDO thread is not available in the secondary replica after an availability database is dropped in SQL Server Q4017445 KB4017445 January 26, 2021
• 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server 2012 Always-On Availability Groups Q4017080 KB4017080 January 26, 2021
• 4017023 SQL Server 2012, 2014 or 2016 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2 Q4017023 KB4017023 January 26, 2021
• 4016949 Unified Showplan Schema for different versions of SQL Server Q4016949 KB4016949 January 26, 2021
• 4016946 FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016 Q4016946 KB4016946 January 26, 2021
• 4016945 FIX: "The custom resolver for this article requires OLEAUT32.DLL with a minimum version of 2.40.4276" error with merge publication in SQL Server Q4016945 KB4016945 January 26, 2021
• 4016902 FIX: Access violation when you use SELECT TOP query to retrieve data from clustered columnstore index in SQL Server 2016 Q4016902 KB4016902 January 26, 2021
• 4016361 FIX: Service Broker endpoint connections aren't closed after an availability group failover in SQL Server Q4016361 KB4016361 January 26, 2021
• 4015093 FIX: "rsUnknownReportParameter" error when you click a report from search results in SSRS 2016 Q4015093 KB4015093 January 26, 2021
• 4014862 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016 Q4014862 KB4014862 January 26, 2021
• 4014756 FIX: SQL Server Profiler fails to obfuscate sp_setapprole when it's executed from a remote procedure call in SQL Server Q4014756 KB4014756 January 26, 2021
• 4014738 FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server Q4014738 KB4014738 January 26, 2021
• 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 Q4014734 KB4014734 January 26, 2021
• 4014002 Improvement: Enables SQL Server Managed Backup to back up databases that are larger than 50 GB to Microsoft Azure in SQL Server 2016 Q4014002 KB4014002 January 26, 2021
• 4013936 FIX: Hadoop File System Task fails after 10 minutes when you open and run a saved SSIS 2016 package Q4013936 KB4013936 January 26, 2021
• 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 Q4013851 KB4013851 January 26, 2021
• 4013248 FIX: User authentication failure in SSRS 2016 due to Report Server Web Service URL truncation under Custom Security Extensions deployment Q4013248 KB4013248 January 26, 2021
• 4013247 FIX: SSRS subscriptions fail to run for a report that connects to a SharePoint External list Q4013247 KB4013247 January 26, 2021
• 4013208 FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model Q4013208 KB4013208 January 26, 2021
• 4013128 FIX: Decreased performance and long waits for CLR_AUTO_EVENT and CMEMTHREAD when SQLCLR UDT is used as a stored procedure parameter for a SQL RPC call Q4013128 KB4013128 January 26, 2021
• 4013122 Improvement: Performance improvement for "sequence point algorithm" step in SSAS 2016 Tabular Model transactions Q4013122 KB4013122 January 26, 2021
• 4013120 Improvement: Enable DBCC CLONEDATABASE to clone a full-text object in SQL Server 2016 SP1 Q4013120 KB4013120 January 26, 2021
• 4010984 FIX: Assertion error when dm_exec_query_statistics_xml is used in a query plan that contains certain operators in SQL Server 2016 Q4010984 KB4010984 January 26, 2021
• 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 Q4010344 KB4010344 January 26, 2021
• 4009839 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode Q4009839 KB4009839 January 26, 2021
• 4009794 FIX: Internal Error "FAC_HK_INTERNAL" when you insert or update large number of rows of data into or in a memory-optimized table in SQL Server 2016 Q4009794 KB4009794 January 26, 2021
• 3216543 FIX: Workloads that utilize many frequent, short transactions in SQL Server 2016 and 2017 may consume more CPU than in SQL Server 2014 Q3216543 KB3216543 January 26, 2021
• 3213709 FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services Q3213709 KB3213709 January 26, 2021
• 3213703 FIX: An Always On secondary replica goes into a disconnecting state Q3213703 KB3213703 January 26, 2021
• 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016 Q3213683 KB3213683 January 26, 2021
• 3213524 FIX: Text box is missing when the toggle action is enabled in SSRS 2016 Q3213524 KB3213524 January 26, 2021
• 3213291 FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016 Q3213291 KB3213291 January 26, 2021
• 3213288 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group Q3213288 KB3213288 January 26, 2021
• 3213283 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 Q3213283 KB3213283 January 26, 2021
• 3213263 FIX: Error when creating a stored procedure that uses a synonym together with an index hint in SQL Server 2016 Q3213263 KB3213263 January 26, 2021
• 3213240 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption Q3213240 KB3213240 January 26, 2021
• 3212916 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string Q3212916 KB3212916 January 26, 2021
• 3212789 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 Q3212789 KB3212789 January 26, 2021
• 3212723 FIX: A query that contains a hint against a view that references at least one temporal table in a different database generates a dump file in SQL Server 2016 Q3212723 KB3212723 January 26, 2021
• 3212523 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory Q3212523 KB3212523 January 26, 2021
• 3212482 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 Q3212482 KB3212482 January 26, 2021
• 3212227 FIX: You can't run a data cleanse against a view in SQL Server 2016 Data Quality Services Q3212227 KB3212227 January 26, 2021
• 3212214 FIX: Cannot execute the DBCC CLONEDATABASE command on an instance of SQL Server 2014 or 2016 after an in-place upgrade Q3212214 KB3212214 January 26, 2021
• 3211991 FIX: SQL Server 2016 Reporting Services mobile reports can't be rendered in your browser through Active Directory Application Proxy Q3211991 KB3211991 January 26, 2021
• 3211948 FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage Q3211948 KB3211948 January 26, 2021
• 3211646 FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016 Q3211646 KB3211646 January 26, 2021
• 3211605 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode Q3211605 KB3211605 January 26, 2021
• 3211602 FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016 Q3211602 KB3211602 January 26, 2021
• 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 Q3211338 KB3211338 January 26, 2021
• 3211304 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 Q3211304 KB3211304 January 26, 2021
• 3210747 FIX: The “sys.dm_db_column_store_row_group_physical_stats” query runs slowly on SQL Server 2016 Q3210747 KB3210747 January 26, 2021
• 3210708 FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates Q3210708 KB3210708 January 26, 2021
• 3210699 FIX: Errors are logged if database mirroring is configured by Transact-SQL in SQL Server 2016 Q3210699 KB3210699 January 26, 2021
• 3210597 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 Q3210597 KB3210597 January 26, 2021
• 3210395 FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016 Q3210395 KB3210395 January 26, 2021
• 3210111 GDR update package for SQL Server 2016 RTM Q3210111 KB3210111 January 26, 2021
• 3210110 On-demand hotfix update package for SQL Server 2016 CU3 Q3210110 KB3210110 January 26, 2021
• 3210089 GDR update package for SQL Server 2016 SP1 Q3210089 KB3210089 January 26, 2021
• 3210087 FIX: Errors when you try to save MDS business rules in SQL Server 2016 Q3210087 KB3210087 January 26, 2021
• 3209896 Can't change PolyBase service accounts without reinstalling the PolyBase feature in SQL Server 2016 Q3209896 KB3209896 January 26, 2021
• 3209878 FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled Q3209878 KB3209878 January 26, 2021
• 3209520 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly Q3209520 KB3209520 January 26, 2021
• 3209459 FIX: Error 21050 when you remove a table that is not part of a publication in SQL Server 2014 or 2016 Q3209459 KB3209459 January 26, 2021
• 3209443 Update improves the stability of SQL Server Management Studio when exiting or removing a connection from Object Explorer Q3209443 KB3209443 January 26, 2021
• 3209442 FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server MDM report Q3209442 KB3209442 January 26, 2021
• 3209426 FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state Q3209426 KB3209426 January 26, 2021
• 3208524 FIX: You cannot select any replica when you fail over from an availability group that's in the resolving state Q3208524 KB3208524 January 26, 2021
• 3208484 "Only secure content is displayed" warning when you open a SQL Server 2016 SP1 Reporting Services report or web portal Q3208484 KB3208484 January 26, 2021
• 3208483 You cannot print in Reporting Services reports after you install SQL Server 2016 SP1 Q3208483 KB3208483 January 26, 2021
• 3208460 FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 CU5 Q3208460 KB3208460 January 26, 2021
• 3208326 FIX: Can't take ownership of an availability group after the owner is dropped in SQL Server 2014 or 2016 Q3208326 KB3208326 January 26, 2021
• 3208276 Update improves handling of documents too large for Full-Text Search indexing in SQL Server Q3208276 KB3208276 January 26, 2021
• 3208246 Updates to DBCC CLONEDATABASE functionality in SQL Server 2014 and 2016 Q3208246 KB3208246 January 26, 2021
• 3208245 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 Q3208245 KB3208245 January 26, 2021
• 3208243 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 Q3208243 KB3208243 January 26, 2021
• 3208179 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services Q3208179 KB3208179 January 26, 2021
• 3208178 FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services Q3208178 KB3208178 January 26, 2021
• 3207512 Important update for SQL Server 2016 SP1 Reporting Services Q3207512 KB3207512 January 26, 2021
• 3207327 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server Q3207327 KB3207327 January 26, 2021
• 3206584 FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables in SQL Server 2016 Q3206584 KB3206584 January 26, 2021
• 3206401 FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016 Q3206401 KB3206401 January 26, 2021
• 3206299 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 Always On availability group Q3206299 KB3206299 January 26, 2021
• 3205994 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 Q3205994 KB3205994 January 26, 2021
• 3205964 FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016 Q3205964 KB3205964 January 26, 2021
• 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 Q3205935 KB3205935 January 26, 2021
• 3205411 FIX: "Non-yielding Scheduler" condition when you parallel-load data into a columnstore index in SQL Server 2016 Q3205411 KB3205411 January 26, 2021
• 3204804 Improvement: New sys.dm_db_stats_histogram Dynamic Management View is available in SQL Server 2016 SP1 CU2 Q3204804 KB3204804 January 26, 2021
• 3204769 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 Q3204769 KB3204769 January 26, 2021
• 3204469 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication Q3204469 KB3204469 January 26, 2021
• 3204265 FIX: Image maps not rendered as expected in SSRS custom report item Q3204265 KB3204265 January 26, 2021
• 3202425 Improvement: Improves the query performance for SQL Server 2016 by changing the use of histograms on UNIQUE columns Q3202425 KB3202425 January 26, 2021
• 3201865 FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server Q3201865 KB3201865 January 26, 2021
• 3201554 FIX: Long compilation time for a query that contains many distinct operators in SQL Server 2016 Q3201554 KB3201554 January 26, 2021
• 3201552 Update adds overall query execution statistics information to the STATISTICS XML output in SQL Server 2012, 2014 and 2016 Q3201552 KB3201552 January 26, 2021
• 3201416 FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 or 2016 Q3201416 KB3201416 January 26, 2021
• 3200975 FIX: Assertion occurs when you use parallel redo in a secondary replica of a SQL Server AlwaysOn Availability Group Q3200975 KB3200975 January 26, 2021
• 3199177 Master Data Management (MDM) Support for Microsoft SQL Server 2016 Q3199177 KB3199177 January 26, 2021
• 3199171 On-demand hotfix update package for SQL Server 2016 CU2 Q3199171 KB3199171 January 26, 2021
• 3198827 FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members Q3198827 KB3198827 January 26, 2021
• 3198826 FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services Q3198826 KB3198826 January 26, 2021
• 3198766 FIX: Error 19432 after you upgrade Availability replicas in an Always On Availability Group to CU1 for SQL Server 2016 Q3198766 KB3198766 January 26, 2021
• 3198760 FIX: Error 19432 and time-out errors with SQL Server 2016 AlwaysOn Availability Groups Q3198760 KB3198760 January 26, 2021
• 3198356 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services Q3198356 KB3198356 January 26, 2021
• 3198285 FIX: Parallel insert operation into a temp table causes SQL Server 2016 to freeze Q3198285 KB3198285 January 26, 2021
• 3198261 FIX: MDS business rule doesn't work if the Code value contains a leading space in SQL Server MDS Add-in for Excel Q3198261 KB3198261 January 26, 2021
• 3197952 FIX: Performance regression in the expression service during numeric arithmetic operations in SQL Server 2016 Q3197952 KB3197952 January 26, 2021
• 3197893 FIX: Rolling upgrade for AlwaysOn replica fails after Cumulative Update 1 for SQL Server 2016 is installed Q3197893 KB3197893 January 26, 2021
• 3197883 FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication Q3197883 KB3197883 January 26, 2021
• 3197879 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent Q3197879 KB3197879 January 26, 2021
• 3197758 FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model) Q3197758 KB3197758 January 26, 2021
• 3197631 FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server Q3197631 KB3197631 January 26, 2021
• 3197605 FIX: SQL Server 2016 hangs when you restore databases that contain memory-optimized tables Q3197605 KB3197605 January 26, 2021
• 3197589 FIX: Heap scan may cause high PAGEIOLATCH_SH waits in SQL Server 2016 Q3197589 KB3197589 January 26, 2021
• 3197403 FIX: SQL Server 2016 Reporting Services keeps cycling to unload application domains when Report Server is configured on a Network Load Balancing Cluster Q3197403 KB3197403 January 26, 2021
• 3196450 FIX: The plaintext password is exposed in the connection string in SQL Server 2016 Analysis Services Q3196450 KB3196450 January 26, 2021
• 3196102 FIX: Performance issues caused by continuous growth of memory in SQL Server 2016 Analysis Services Q3196102 KB3196102 January 26, 2021
• 3196100 FIX: Exception occurs during parallel processing of partitions if a column is re-encoded in SQL Server 2016 Q3196100 KB3196100 January 26, 2021
• 3196012 FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server Q3196012 KB3196012 January 26, 2021
• 3195901 FIX: SQL Server 2016 crashes when a Tuple Mover task is ended unexpectedly Q3195901 KB3195901 January 26, 2021
• 3195825 FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016 Q3195825 KB3195825 January 26, 2021
• 3195813 On-demand hotfix update package for SQL Server 2016 CU2 Q3195813 KB3195813 January 26, 2021
• 3194365 FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking Q3194365 KB3194365 January 26, 2021
• 3192738 SQL Server 2016 installer updates Q3192738 KB3192738 January 26, 2021
• 3192692 FIX: Assert memory dump on a mirror server in SQL Server Q3192692 KB3192692 January 26, 2021
• 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 Q3192636 KB3192636 January 26, 2021
• 3192154 A non-optimal query plan choice causes poor performance when values outside the range represented in statistics are searched in SQL Server 2016 and 2017 Q3192154 KB3192154 January 26, 2021
• 3192117 Access violation when you run a query if trace flag 4139 is enabled in SQL Server 2016 Q3192117 KB3192117 January 26, 2021
• 3191515 Incorrect mobile report filtering when the parameter contains special characters in SQL Server 2016 Reporting Services Q3191515 KB3191515 January 26, 2021
• 3191273 Update adds support for self-referential constraints in the new Referential Integrity Operator in SQL Server 2016 Q3191273 KB3191273 January 26, 2021
• 3191062 FIX: FileTable directory stops responding when you create multiple files concurrently in SQL Server 2014 or 2016 Q3191062 KB3191062 January 26, 2021
• 3190871 New sys.dm_exec_query_statistics_xml Dynamic Management Function is available in SQL Server 2016 SP1 Q3190871 KB3190871 January 26, 2021
• 3190762 Update to improve diagnostics for query execution plans that involve residual predicate pushdown in SQL Server 2016 Q3190762 KB3190762 January 26, 2021
• 3190548 Update introduces CREATE OR ALTER Transact-SQL statement in SQL Server 2016 Q3190548 KB3190548 January 26, 2021
• 3189959 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment Q3189959 KB3189959 January 26, 2021
• 3189855 FIX: Intermittent non-yielding conditions, performance problems and intermittent connectivity failures in SQL Server 2016 Q3189855 KB3189855 January 26, 2021
• 3189813 Update introduces USE HINT query hint argument in SQL Server 2016 Q3189813 KB3189813 January 26, 2021
• 3189709 FIX: Installation of Cumulative Update 1 for SQL Server 2016 fails on a named instance Q3189709 KB3189709 January 26, 2021
• 3189687 FIX: "'Salt' attribute for Password is missing in the project manifest" error in SQL Server Q3189687 KB3189687 January 26, 2021
• 3189663 FIX: SQL Server error log incorrectly cites logical processors when soft-NUMA is enabled Q3189663 KB3189663 January 26, 2021
• 3189655 Error 33294 if a cursor is declared by using the OPTION (RECOMPILE) query hint in SQL Server 2016 Q3189655 KB3189655 January 26, 2021
• 3189372 Query returns incorrect results from nonclustered columnstore index under snapshot isolation level in SQL Server 2016 Q3189372 KB3189372 January 26, 2021
• 3189364 Query Store returns unusual characters when a JOIN operator is used in SQL Server 2016 Q3189364 KB3189364 January 26, 2021
• 3189264 Incorrect results are returned when you run a query that contains a GROUP BY operation in SQL Server 2016 Q3189264 KB3189264 January 26, 2021
• 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server Q3189229 KB3189229 January 26, 2021
• 3189060 Standard edition of SQL Server 2016 Analysis Services (Tabular mode) ignores the 16 GB memory limit Q3189060 KB3189060 January 26, 2021
• 3188978 FIX: "Cannot bulk load" error when you run a query that contains an UPDATE statement in SQL Server 2016 Q3188978 KB3188978 January 26, 2021
• 3188950 Updating while compression is in progress can lead to nonclustered columnstore index corruption in SQL Server 2016 Q3188950 KB3188950 January 26, 2021
• 3188454 Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server Q3188454 KB3188454 January 26, 2021
• 3188368 FIX: Access violation on secondary replica when there are too many parallel redo operations in SQL Server 2016 Q3188368 KB3188368 January 26, 2021
• 3188160 FIX: Can't add new explicit hierarchies after deleting existing explicit hierarchies from an entity in SQL Server 2016 Master Data Services Q3188160 KB3188160 January 26, 2021
• 3188158 FIX: Filter and Change Tracking settings are removed after you change a domain-based attribute in SQL Server 2016 Master Data Services Q3188158 KB3188158 January 26, 2021
• 3188157 Functional area permissions are lost after you upgrade to SQL Server 2016 Master Data Services Q3188157 KB3188157 January 26, 2021
• 3188154 FIX: Can't filter attributes when using SQL Server 2016 Master Data Services Add-in on a non-English version of Excel Q3188154 KB3188154 January 26, 2021
• 3188153 FIX: Long time required to purge many members from an entity in SQL Server 2016 Master Data Services Q3188153 KB3188153 January 26, 2021
• 3188151 FIX: Can't save a business rule when the condition and action refer to different parent entities in SQL Server 2016 Master Data Services Q3188151 KB3188151 January 26, 2021
• 3188150 Version copy fails when an entity contains collections but not consolidated members in SQL Server 2016 MDS Q3188150 KB3188150 January 26, 2021
• 3187549 FIX: Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services Q3187549 KB3187549 January 26, 2021
• 3187493 FIX: DISCOVER_TABLE_STORAGE_COLUMN_SEGMENTS DMV returns an incorrect result of memory usage in SQL Server 2016 Q3187493 KB3187493 January 26, 2021
• 3186435 FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed or stops working after applying SQL Server update Q3186435 KB3186435 January 26, 2021
• 3186433 FIX: Cannot print a SQL Server Reporting Services 2016 report from an application by using Report Viewer Control Q3186433 KB3186433 January 26, 2021
• 3184227 "The remote server '(null)' does not exist" error occurs after you remove an article from a publication in SQL Server Q3184227 KB3184227 January 26, 2021
• 3184135 Can't open a Reporting Services report from the SSRS portal when the host computer has FIPS compliance enabled Q3184135 KB3184135 January 26, 2021
• 3184099 SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy Q3184099 KB3184099 January 26, 2021
• 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 Q3183721 KB3183721 January 26, 2021
• 3183686 FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS Q3183686 KB3183686 January 26, 2021
• 3183440 Error when you use SecurityFilteringBehavior enumeration in SQL Server 2016 Analysis Services Q3183440 KB3183440 January 26, 2021
• 3183345 FIX: Publication contains column filters stops working after restored from SQL Server 2005 to SQL Server 2012,2014 or 2016 Q3183345 KB3183345 January 26, 2021
• 3182868 FIX: Queries that contain recursive CROSS APPLY operations run slowly in SQL Server 2016 Q3182868 KB3182868 January 26, 2021
• 3181526 Calculation using two measure time values in iterations returns negative values in SQL Server 2012, 2014, or 2016 Q3181526 KB3181526 January 26, 2021
• 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server Q3181444 KB3181444 January 26, 2021
• 3181260 SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server Q3181260 KB3181260 January 26, 2021
• 3180980 Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected Q3180980 KB3180980 January 26, 2021
• 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 or 2016 Analysis Services Q3180263 KB3180263 January 26, 2021
• 3180060 FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016 Q3180060 KB3180060 January 26, 2021
• 3179258 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) Q3179258 KB3179258 January 26, 2021
• 3178934 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) Q3178934 KB3178934 January 26, 2021
• 3178541 PivotTable connects to incorrect data source in SQL Server PowerPivot for SharePoint Q3178541 KB3178541 January 26, 2021
• 3178297 Query Store automatic data cleanup fails on editions other than Enterprise and Developer edition of SQL Server 2016 Q3178297 KB3178297 January 26, 2021
• 3178137 FIX: Potential loss of historical data when you alter an in-memory temporal table in SQL Server 2016 Q3178137 KB3178137 January 26, 2021
• 3178107 SQL Server crashes because of an access violation error that occurs while it reads data from an event file target Q3178107 KB3178107 January 26, 2021
• 3177838 How to use DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server Q3177838 KB3177838 January 26, 2021
• 3177238 FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server Q3177238 KB3177238 January 26, 2021
• 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Q3176993 KB3176993 January 26, 2021
• 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016 Q3176440 KB3176440 January 26, 2021
• 3175883 Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server Q3175883 KB3175883 January 26, 2021
• 3175478 FIX: It takes a long time to compile a query and add it to the Query Store in SQL Server 2016 Q3175478 KB3175478 January 26, 2021
• 3175203 FIX: ShortestLineTo() and STDistance() methods return incorrect result for the shortest distance in SQL Server 2016 Q3175203 KB3175203 January 26, 2021
• 3175018 Improvements and fixes for SQL Server 2016 R Services Q3175018 KB3175018 January 26, 2021
• 3174963 FIX: Data loss when you alter column operation on a large memory-optimized table in SQL Server 2016 Q3174963 KB3174963 January 26, 2021
• 3174829 FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016 Q3174829 KB3174829 January 26, 2021
• 3174788 The Customer Experience Improvement Program is disabled after FIPS compliance is enabled in SQL Server 2016 Q3174788 KB3174788 January 26, 2021
• 3174713 Data Flush Tasks of a memory-optimized temporal table may consume 100-percent CPU usage in SQL Server 2016 Q3174713 KB3174713 January 26, 2021
• 3174712 A deadlock condition occurs when you make updates on a memory-optimized temporal table and you run the SWITCH PARTITION statement on a history table in SQL Server 2016 Q3174712 KB3174712 January 26, 2021
• 3174711 SYSTEM_VERSIONING is not turned on for a table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled in SQL Server 2016 Q3174711 KB3174711 January 26, 2021
• 3174710 Audit record is missing when you turn on SYSTEM_VERSIONING for a table by using the ALTER TABLE statement in SQL Server 2016 Q3174710 KB3174710 January 26, 2021
• 3174708 A memory leak occurs when DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table in SQL Server 2016 Q3174708 KB3174708 January 26, 2021
• 3174684 FIX: SQL Server 2016 uses all available memory and crashes when it runs a query that contains HASHBYTES functions Q3174684 KB3174684 January 26, 2021
• 3174674 The full-text search feature does not always return the expected results in SQL Server 2016 Q3174674 KB3174674 January 26, 2021
• 3174436 FIX: Failed execution of ALTER AUDIT statement causes SQL Server to crash in SQL Server 2016 Q3174436 KB3174436 January 26, 2021
• 3174433 FIX: Error 10635 when you rebuild indexes online for tables that contain large object (LOB) columns in SQL Server 2016 Q3174433 KB3174433 January 26, 2021
• 3174395 FIX: sys.dm_external_script_execution_stats returns an incorrect counter_value in SQL Server 2016 Q3174395 KB3174395 January 26, 2021
• 3174393 Windows Authentication doesn't work when you connect to SQL Server from R Script on SQL Server 2016 Express Edition Q3174393 KB3174393 January 26, 2021
• 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 Q3174370 KB3174370 January 26, 2021
• 3174088 FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016 Q3174088 KB3174088 January 26, 2021
• 3173989 FIX: Availability databases are not fully started after you restart the server instance of SQL Server 2016 Q3173989 KB3173989 January 26, 2021
• 3173976 FIX: Fatal Error when you run a query against the sys.sysindexes view in SQL Server 2016 Q3173976 KB3173976 January 26, 2021
• 3173975 FIX: Checkpoint files are missing from sys.dm_db_xtp_checkpoint_files on SQL Server 2016 Q3173975 KB3173975 January 26, 2021
• 3173957 FIX: Cannot install a non-English version of SQL Server 2016 on a Windows Server that is installed in Server Core mode Q3173957 KB3173957 January 26, 2021
• 3173841 A data flush task may cause a deadlock condition when queries are executed on a memory-optimized table in SQL Server 2016 Q3173841 KB3173841 January 26, 2021
• 3173784 An unexpected error occurs when you execute a DAX query that contains variables in SQL Server 2016 Analysis Services Q3173784 KB3173784 January 26, 2021
• 3173781 FIX: Unexpected exception when you make cross-appdomain TOM call in SQL Server 2016 Q3173781 KB3173781 January 26, 2021
• 3173779 FIX: Can’t create a database with a used database name by using the Create or CreateOrReplace command in SQL Server 2016 Q3173779 KB3173779 January 26, 2021
• 3173766 FIX: DBCC CHECKDB or CHECKTABLE returns false positives for data corruption and assertion failures in SQL Server 2014 or 2016 Q3173766 KB3173766 January 26, 2021
• 3173666 The .NET Framework 3.5 is required when you configure SQL Server 2016 as a secondary in Transaction Log Shipping Q3173666 KB3173666 January 26, 2021
• 3173472 SECURITY_CRYPTO_CONTEXT_MUTEX waits cause SQL Server 2016 to stop responding to client requests in SQL Server 2014 and 2016 Q3173472 KB3173472 January 26, 2021
• 3173471 FIX: "Could not redo log record" error, and replica is suspended in SQL Server 2016, 2014, or 2012 Q3173471 KB3173471 January 26, 2021
• 3173436 Behavior changes when you add uniqueidentifier columns in a clustered Columnstore Index in SQL Server 2016 Q3173436 KB3173436 January 26, 2021
• 3173157 Adds a stored procedure for the manual cleanup of the change tracking side table in SQL Server Q3173157 KB3173157 January 26, 2021
• 3173156 Update adds AlwaysOn extended events and performance counters in SQL Server 2014 or 2016 Q3173156 KB3173156 January 26, 2021
• 3173087 FIX: PolyBase feature doesn't install when you add a node to a SQL Server 2016 failover cluster Q3173087 KB3173087 January 26, 2021
• 3173065 SQL Server 2016 generates a dump file when you execute an external script in parallel mode Q3173065 KB3173065 January 26, 2021
• 3173043 FIX: Wrong "schema_name" and "class_type" values for the CREATE SECURITY POLICY statement in SQL Server 2016 Q3173043 KB3173043 January 26, 2021
• 3173038 Performance issues occur when using the sys.dm_hadr_availability_replica_states DMV on an AlwaysOn Availability Group that contains many databases in SQL Server 2016 Q3173038 KB3173038 January 26, 2021
• 3173004 Data loss or incorrect results occur when you use the sp_settriggerorder stored procedure in SQL Server 2016 Q3173004 KB3173004 January 26, 2021
• 3172998 FIX: A severe error when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014 or 2016 Q3172998 KB3172998 January 26, 2021
• 3172997 Update to add a memory grant warning to the Showplan XML in SQL Server 2014 or 2016 Q3172997 KB3172997 January 26, 2021
• 3172981 FIX: Home page of SSRS web portal becomes empty after you enable My Reports feature in SQL Server 2016 Q3172981 KB3172981 January 26, 2021
• 3172974 FIX: Incorrect number of rows in sys.partitions for a columnstore index in SQL Server 2016 Q3172974 KB3172974 January 26, 2021
• 3172973 FIX: Assertion failure when you run UNION or UNION ALL clauses on a Row-Level Security enabled table in SQL Server 2016 Q3172973 KB3172973 January 26, 2021
• 3172959 FIX: Error 8061 when you use BULK INSERT on a table in SQL Server 2016 Q3172959 KB3172959 January 26, 2021
• 3172787 FIX: Can't force Row Mode sort by using session or query level trace flag 9347 in SQL Server 2016 Q3172787 KB3172787 January 26, 2021
• 3172671 FIX: BULK INSERT or OPENROWSET import wrong data if UTF-8 encoded file does not have a BOM in SQL Server 2016 Q3172671 KB3172671 January 26, 2021
• 3171932 FIX: Error message isn't localized completely when you use Tabular Model Scripting Language (TMSL) in SQL Server 2016 Q3171932 KB3171932 January 26, 2021
• 3171884 FIX: Unexpected exception when you add more maintenance plan tasks for an instance of SQL Server 2012 in SSMS 2016 Q3171884 KB3171884 January 26, 2021
• 3171882 FIX: SSMS can't save maintenance plans when you connect to an instance of SQL Server 2008 R2 or earlier versions Q3171882 KB3171882 January 26, 2021
• 3171863 FIX: Secondary replica in "not healthy" state after you upgrade the primary database in SQL Server 2016 Q3171863 KB3171863 January 26, 2021
• 3171759 A query that accesses data in a columnstore index causes the Database Engine to receive a floating point exception in SQL Server 2016 Q3171759 KB3171759 January 26, 2021
• 3171574 AMO enumeration TraceEventSubclass does not expose member for JsonCommand event subclass in SQL Server 2016 Q3171574 KB3171574 January 26, 2021
• 3171555 Adds trace flag 9358 to disable batch mode sort operations in a complex parallel query in SQL Server 2016 Q3171555 KB3171555 January 26, 2021
• 3171544 FIX: Error 8624 occurs when you run a query against a nonclustered columnstore index in SQL Server 2016 Q3171544 KB3171544 January 26, 2021
• 3171532 Drilling through from one mobile report to another does not respect the embed parameter specified in a URL in SQL Server 2016 Reporting Services Q3171532 KB3171532 January 26, 2021
• 3171516 Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Q3171516 KB3171516 January 26, 2021
• 3171505 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain Q3171505 KB3171505 January 26, 2021
• 3171489 The Apply button on the Parameter Properties page is not localized in SQL Server 2016 Reporting Services web portal Q3171489 KB3171489 January 26, 2021
• 3171480 FIX: Can't retrieve favorite KPIs or mobile reports in Power BI Mobile app or GetCatalogItem API in SQL Server 2016 Q3171480 KB3171480 January 26, 2021
• 3171475 FIX: Can't rename a catalog item with the same name in different case in SSRS 2016 Q3171475 KB3171475 January 26, 2021
• 3171470 SQL Server 2016 Reporting Services does not upload Service Quality Monitoring data collections Q3171470 KB3171470 January 26, 2021
• 3171467 Can't pin an SSRS report to Power BI dashboards when you are not a member of any groups on PowerBI.com website Q3171467 KB3171467 January 26, 2021
• 3171085 A report configured to automatically refresh causes errors after the web browser idles for a while in SQL Server 2016 Reporting Services Q3171085 KB3171085 January 26, 2021
• 3171040 "HTTP 503: Service unavailable" error when you open the SSRS web portal after you upgrade to SSRS 2016 Q3171040 KB3171040 January 26, 2021
• 3171002 SQL Server 2016 database log restore fails with the "Hk Recovery LSN is not NullLSN" error message Q3171002 KB3171002 January 26, 2021
• 3171001 FIX: Slow database recovery in SQL Server 2016 due to large log when you use In-Memory OLTP on a high-end computer Q3171001 KB3171001 January 26, 2021
• 3170999 FIX: Heavy concurrent OLTP activity runs slowly when delayed durability is enabled in SQL Server 2016 Q3170999 KB3170999 January 26, 2021
• 3170996 Creating or updating statistics takes a long time on a large memory-optimized table in SQL Server 2016 Q3170996 KB3170996 January 26, 2021
• 3170528 The "BackgroundColor" property is not respected when it is specified by an expression in SQL Server 2016 Reporting Services Q3170528 KB3170528 January 26, 2021
• 3170359 Improvements and fixes for SSRS 2016 mobile report Q3170359 KB3170359 January 26, 2021
• 3170293 Product Update feature doesn't update SQL Server Setup support files during non-English slipstreamed installation of SQL Server 2016 Q3170293 KB3170293 January 26, 2021
• 3170214 FIX: Can't generate an SSIS package when you use SQL Server Import and Export Wizard in SQL Server 2016 Q3170214 KB3170214 January 26, 2021
• 3170145 FIX: SSIS package doesn't run when you call it from executable files outside the DTS\Binn folder in SQL Server 2016 Q3170145 KB3170145 January 26, 2021
• 3170142 Buffer size is not set correctly when AutoAdjustBufferSize is enabled in SQL Server Data Tools in Visual Studio 2015 Q3170142 KB3170142 January 26, 2021
• 3170140 Adds the adjusted buffer size to the BufferSizeTuning event when AutoAdjustBufferSize is enabled in SSIS 2016 Q3170140 KB3170140 January 26, 2021
• 3170123 Supports DROP TABLE DDL for articles that are included in transactional replication in SQL Server 2014 or in SQL Server 2016 SP1 Q3170123 KB3170123 January 26, 2021
• 3170116 FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server Q3170116 KB3170116 January 26, 2021
• 3170115 Information about enabled trace flags is added to the showplan XML in SQL Server Q3170115 KB3170115 January 26, 2021
• 3170114 Update to add DMF sys.dm_db_incremental_stats_properties in SQL Server 2014 or 2016 Q3170114 KB3170114 January 26, 2021
• 3170112 Update to expose maximum memory enabled for a single query in Showplan XML in SQL Server 2014 or 2016 Q3170112 KB3170112 January 26, 2021
• 3170085 Domain-based attributes created by MDS Add-in for Excel are unavailable in SQL Server 2016 Q3170085 KB3170085 January 26, 2021
• 3170084 FIX: Can't insert the NULL value into "ArgumentScript" column when you apply a business rule in SQL Server 2016 MDS Q3170084 KB3170084 January 26, 2021
• 3170083 FIX: Exception occurs when you associate an availability database with MDS web application in SQL Server 2016 Q3170083 KB3170083 January 26, 2021
• 3170082 FIX: Permission issue or failure occurs when you upgrade to SQL Server 2016 Master Data Services Q3170082 KB3170082 January 26, 2021
• 3170081 Deadlock occurs with parallel operations in SQL Server 2016 Master Data Services Q3170081 KB3170081 January 26, 2021
• 3170080 Slow performance when SQL Server 2016 Master Data Services is used on large MDS databases Q3170080 KB3170080 January 26, 2021
• 3170079 FIX: Permission issues when you use SQL Server 2016 Master Data Services Q3170079 KB3170079 January 26, 2021
• 3170078 Can't create an MDS website through a low-privilege account in SQL Server 2016 Q3170078 KB3170078 January 26, 2021
• 3170076 FIX: Data loss when you run the udpConvertCollectionAndConsolidatedMembersToLeaf stored procedure in SQL Server 2016 MDS Q3170076 KB3170076 January 26, 2021
• 3170074 FIX: Unexpected exception occurs when deploying a package using SQL Server 2016 MDSModelDeploy tool Q3170074 KB3170074 January 26, 2021
• 3170071 SQL Server 2016 cannot send diagnostics information for MDS web application and MDS Add-in for Excel Q3170071 KB3170071 January 26, 2021
• 3170068 An unhandled exception occurs after a filter is applied on an attribute in SQL Server 2016 Master Data Services Q3170068 KB3170068 January 26, 2021
• 3170061 An unhandled exception occurs when you reopen a saved workbook that contains MDS entities in SQL Server 2016 Q3170061 KB3170061 January 26, 2021
• 3170051 FIX: SQL Server failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting Q3170051 KB3170051 January 26, 2021
• 3170015 DMV sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014 Q3170015 KB3170015 January 26, 2021
• 3169923 Fixes some issues about assistive technology tools in SSRS 2016 Q3169923 KB3169923 January 26, 2021
• 3169922 Cannot create a new subscription for a report that contains Unicode characters in SQL Server 2016 Reporting Services web portal Q3169922 KB3169922 January 26, 2021
• 3169921 Update to fix layout issues in SQL Server 2016 Reporting Services (SSRS) web portal Q3169921 KB3169921 January 26, 2021
• 3168793 FIX: Cannot create or delete a table or index when another DDL transaction is running on the same database in SQL Server 2016 Q3168793 KB3168793 January 26, 2021
• 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 Q3168740 KB3168740 January 26, 2021
• 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016 Q3168710 KB3168710 January 26, 2021
• 3168709 SQL Server doesn't start after you configure the tempdb database to use a very small log file Q3168709 KB3168709 January 26, 2021
• 3168708 FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server Q3168708 KB3168708 January 26, 2021
• 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016 Q3168707 KB3168707 January 26, 2021
• 3168691 Can't install Microsoft R Server (Standalone) on a Windows Server Core operating system Q3168691 KB3168691 January 26, 2021
• 3168571 FIX: The SEEDING_MODE setting is ignored when you add an AlwaysOn AG replica to an existing AG in SQL Server 2016 Q3168571 KB3168571 January 26, 2021
• 3168570 Update adds FIPS-compliant support in SQL Server 2016 Q3168570 KB3168570 January 26, 2021
• 3168257 Setup UI changes to English if a non-English version of SQL Server 2016 GDR update is installed using the Product Update feature Q3168257 KB3168257 January 26, 2021
• 3168242 FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode) Q3168242 KB3168242 January 26, 2021
• 3168200 FIX: Only one Boolean parameter can select default value when you have multiple Boolean parameters in SSRS 2016 Q3168200 KB3168200 January 26, 2021
• 3167434 FIX: SSRS logs fill up the hard disk and agent jobs are not recreated after database migration in SQL Server 2016 Q3167434 KB3167434 January 26, 2021
• 3167175 FIX: The "Select All" check box doesn't work in the subscriptions page in SSRS 2016 Q3167175 KB3167175 January 26, 2021
• 3167174 FIX: Subscriptions that are filtered out are still affected by the actions in SSRS 2016 Q3167174 KB3167174 January 26, 2021
• 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan Q3167159 KB3167159 January 26, 2021
• 3167113 Analysis Services may crash if the HeapTypeForObjects memory property is configured by a slot allocator in SQL Server 2016 Q3167113 KB3167113 January 26, 2021
• 3166120 FIX: "Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'" error in SQL Server 2016 Q3166120 KB3166120 January 26, 2021
• 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR in SQL Server Q3165545 KB3165545 January 26, 2021
• 3165168 Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server Q3165168 KB3165168 January 26, 2021
• 3163924 AUTOGROW_ALL_FILES and READ_ONLY aren't either updated by DDL or preserved after a database restarts in SQL Server 2016 Q3163924 KB3163924 January 26, 2021
• 3162858 "The log backup chain is broken" error when the log backup process fails in SQL Server Q3162858 KB3162858 January 26, 2021
• 3162589 FIX: Decreased SQL Server performance when there is elevated privileged mode CPU usage and a high volume of page latch waits Q3162589 KB3162589 January 26, 2021
• 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Q3162396 KB3162396 January 26, 2021
• 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 Q3161403 KB3161403 January 26, 2021
• 3161119 FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 or 2016 Q3161119 KB3161119 January 26, 2021
• 3160303 FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 Q3160303 KB3160303 January 26, 2021
• 3159748 FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2014 or 2016 Q3159748 KB3159748 January 26, 2021
• 3158710 FIX: The ALTER SERVER CONFIGURATION with SET SOFTNUMA command does not work in SQL Server 2016 Q3158710 KB3158710 January 26, 2021
• 3158388 FIX: SQL Server 2016 MDS database is not visible in SQL Server 2012 MDS Configuration Manager Q3158388 KB3158388 January 26, 2021
• 3157575 FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server Q3157575 KB3157575 January 26, 2021
• 3156157 Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available Q3156157 KB3156157 January 26, 2021
• 3155503 FIX: MERGE statement to sync tables is unsuccessful when change data capture is enabled in SQL Server 2012, 2014, or 2016 Q3155503 KB3155503 January 26, 2021
• 3155209 FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 Q3155209 KB3155209 January 26, 2021
• 3154226 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server Q3154226 KB3154226 January 26, 2021
• 3153836 Operating system error 32 when you restore a database in SQL Server 2012 SP3, 2014, or 2016 Q3153836 KB3153836 January 26, 2021
• 3152965 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server Q3152965 KB3152965 January 26, 2021
• 3152596 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Q3152596 KB3152596 January 26, 2021
• 3152378 FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server Q3152378 KB3152378 January 26, 2021
• 3152377 FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 or 2016 Q3152377 KB3152377 January 26, 2021
• 3152135 FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 or 2016 Q3152135 KB3152135 January 26, 2021
• 3152042 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Q3152042 KB3152042 January 26, 2021
• 3150896 FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server Q3150896 KB3150896 January 26, 2021
• 3150152 FIX: Estimated number of rows is calculated incorrectly for a predicate involving a unique GUID column in SQL Server 2014 or 2016 Q3150152 KB3150152 January 26, 2021
• 3149128 Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server Q3149128 KB3149128 January 26, 2021
• 3147012 FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads Q3147012 KB3147012 January 26, 2021
• 3146404 FIX: Canceling a backup task crashes SQL Server Q3146404 KB3146404 January 26, 2021
• 3146123 Query plan generation improvement for some columnstore queries in SQL Server 2014 or 2016 Q3146123 KB3146123 January 26, 2021
• 3138321 FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016 Q3138321 KB3138321 January 26, 2021
• 3136496 FIX: Access violation occurs when a query references an SQLCLR function through a synonym in SQL Server 2014 and 2016 Q3136496 KB3136496 January 26, 2021
• 3136205 FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server Q3136205 KB3136205 January 26, 2021
• 3132062 FIX: SMK initialization fails on one node of a SQL Server 2012, 2014, or 2016 failover cluster Q3132062 KB3132062 January 26, 2021
• 3132058 FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server Q3132058 KB3132058 January 26, 2021
• 3131443 FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server Q3131443 KB3131443 January 26, 2021
• 3122088 Sqlps utility fails to run when the "Turn on Script Execution" policy is set to "Allow all scripts" in SQL Server Q3122088 KB3122088 January 26, 2021
• 3115741 FIX:"The process cannot access the file" error when an XML task fails in SQL Server Q3115741 KB3115741 January 26, 2021
• 3107397 Improved diagnostics for query execution plans that involve residual predicate pushdown in SQL Server Q3107397 KB3107397 January 26, 2021
• 3106976 FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016 Q3106976 KB3106976 January 26, 2021
• 3100256 "Log provider "Microsoft.LogProviderSQLServer" is not installed correctly" error when you open the Configure SSIS Logs window Q3100256 KB3100256 January 26, 2021
• 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name Q3070382 KB3070382 January 26, 2021
• 3067968 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 Q3067968 KB3067968 January 26, 2021
• 3065060 FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS Q3065060 KB3065060 January 26, 2021
• 3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database Q3030352 KB3030352 January 26, 2021
• 3028216 FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Q3028216 KB3028216 January 26, 2021
• 3026083 FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server Q3026083 KB3026083 January 26, 2021
• 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Q3025408 KB3025408 January 26, 2021
• 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Q3010148 KB3010148 January 26, 2021
• 3005011 Unexpected growth of tempdb data files when using SQL Server Service Broker Q3005011 KB3005011 January 26, 2021
• 2963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS Q2963836 KB2963836 January 26, 2021
• 2932559 FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS Q2932559 KB2932559 January 26, 2021
• 2925865 Error when you execute SSIS package on FIPS-enabled Windows Q2925865 KB2925865 January 26, 2021
• 2634571 Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option Q2634571 KB2634571 January 26, 2021
• 4534430 Msg 33111 error after SQL Server TDE certificate or key rotation Q4534430 KB4534430 January 25, 2021
• 4458842 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (GDR): August 22, 2018 Q4458842 KB4458842 January 25, 2021
• 4458621 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 21, 2018 Q4458621 KB4458621 January 25, 2021
• 4293808 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (CU): August 14, 2018 Q4293808 KB4293808 January 25, 2021
• 4293807 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018 Q4293807 KB4293807 January 25, 2021
• 4293802 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (GDR): August 14, 2018 Q4293802 KB4293802 January 25, 2021
• 4293801 Description of the security update for the remote code execution vulnerability in SQL Server 2016 SP1 (GDR): August 14, 2018 Q4293801 KB4293801 January 25, 2021
• 4019095 Description of the security update for SQL Server 2016 Service Pack 1 CU: August 8, 2017 Q4019095 KB4019095 January 25, 2021
• 4019089 Description of the security update for SQL Server 2016 Service Pack 1 GDR: August 8, 2017 Q4019089 KB4019089 January 25, 2021
• 4019088 Description of the security update for SQL Server 2016 RTM GDR: August 8, 2017 Q4019088 KB4019088 January 25, 2021
• 4019086 Description of the security update for SQL Server 2016 RTM CU: August 8, 2017 Q4019086 KB4019086 January 25, 2021
• 3203693 “A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10 Q3203693 KB3203693 January 25, 2021
• 3199641 MS16-136: Security update for SQL Server: November 8, 2016 Q3199641 KB3199641 January 25, 2021
• 3194717 MS16-136: Description of the security update for SQL Server 2016 CU: November 8, 2016 Q3194717 KB3194717 January 25, 2021
• 3194716 MS16-136: Description of the security update for SQL Server 2016 GDR: November 8, 2016 Q3194716 KB3194716 January 25, 2021
• 3164398 Critical update for SQL Server 2016 MSVCRT prerequisites Q3164398 KB3164398 January 25, 2021
• 3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later Q3108695 KB3108695 January 25, 2021
• 3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015 Q3045321 KB3045321 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 4587239 FIX: Assertion error occurs when the Availability Group is failed over manually to another replica in SQL Server 2016 Q4587239 KB4587239 January 20, 2021
• 4578496 FIX: Slow performance occurs as CMEMTHREAD waits occur due to temporary table cachestore memory object contention in SQL Server 2016 and 2017 Q4578496 KB4578496 January 20, 2021
• 4578008 FIX: Managed backup is not backing up the database when SQL Agent system jobs are changed to different name other than 'sa' in SQL Server 2016 and 2017 Q4578008 KB4578008 January 20, 2021
• 4576757 FIX: Access violation occurs when you query cloned database in SQL Server 2016 Q4576757 KB4576757 January 20, 2021
• 4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server Q4568653 KB4568653 January 20, 2021
• 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 January 20, 2021
• 4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 January 20, 2021
• 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 January 20, 2021
• 4556096 FIX: SSRS 2016 URLs are case-sensitive after applying Security Update GDRs KB4532097 or KB4535706 Q4556096 KB4556096 January 20, 2021
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 January 20, 2021
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 January 20, 2021
• 4541769 FIX: Error occurs when running sp_updatestats on the table that has a clustered columnstore index and memory optimized index Q4541769 KB4541769 January 20, 2021
• 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 January 20, 2021
• 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 January 20, 2021
• 4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 January 20, 2021
• 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 January 20, 2021
• 4541385 FIX: Database initialization may fail by using automatic seeding in SQL Server 2016 Q4541385 KB4541385 January 20, 2021
• 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 January 20, 2021
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 January 20, 2021
• 4541288 FIX: Non-yielding scheduler dumps occur when running a batch mode query with multiple joins in SQL Server 2016 Q4541288 KB4541288 January 20, 2021
• 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 January 20, 2021
• 4540903 FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016, 2017 and 2019 Q4540903 KB4540903 January 20, 2021
• 4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 January 20, 2021
• 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 January 20, 2021
• 4540731 FIX: Unexpected exception error occurs when you run DISCOVER_CSDL_METADATA in Power BI Desktop in SQL Server 2016 Q4540731 KB4540731 January 20, 2021
• 4540449 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2016, 2017 and 2019 Q4540449 KB4540449 January 20, 2021
• 4540385 FIX: DAX query causes server to have exceptions in TBB heap and crash in Windows heap in SQL Server 2016 and 2017 Q4540385 KB4540385 January 20, 2021
• 4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 January 20, 2021
• 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 January 20, 2021
• 4539947 FIX: Assertion occurs when you run DATABASE SCOPED command in SQL Server 2016 Q4539947 KB4539947 January 20, 2021
• 4539897 FIX: Access violation may occur when you run XML query against a table that has a primary XML index in SQL Server 2016 Q4539897 KB4539897 January 20, 2021
• 4539892 FIX: Error occurs when you run a stored procedure from database A which pulls data from database B in SQL Server 2016 Q4539892 KB4539892 January 20, 2021
• 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 January 20, 2021
• 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 January 20, 2021
• 4538378 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only Q4538378 KB4538378 January 20, 2021
• 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 January 20, 2021
• 4535833 SQL Server Reporting Services XSS vulnerability Q4535833 KB4535833 January 20, 2021
• 4535706 Description of the security update for SQL Server 2016 SP2 CU11: February 11, 2020 Q4535706 KB4535706 January 20, 2021
• 4535305 SQL Server Reporting Services remote code execution vulnerability Q4535305 KB4535305 January 20, 2021
• 4532097 Description of the security update for SQL Server 2016 SP2 GDR: February 11, 2020 Q4532097 KB4532097 January 20, 2021
• 4531027 FIX: Assertion error occurs when you run getHKTable function to get Hekaton database in SQL Server 2016 Q4531027 KB4531027 January 20, 2021
• 4531010 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server Q4531010 KB4531010 January 20, 2021
• 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 January 20, 2021
• 4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server Q4530500 KB4530500 January 20, 2021
• 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 January 20, 2021
• 4530443 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned Q4530443 KB4530443 January 20, 2021
• 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 January 20, 2021
• 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 January 20, 2021
• 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 January 20, 2021
• 4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 Q4529942 KB4529942 January 20, 2021
• 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 January 20, 2021
• 4528130 FIX: Access violation occurs when you restore the In-Memory Optimized database in SQL Server 2016 and 2017 Q4528130 KB4528130 January 20, 2021
• 4528067 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server Q4528067 KB4528067 January 20, 2021
• 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 January 20, 2021
• 4528065 FIX: DBCC CHECKDB with EXTENDED_LOGICAL_CHECKS fails on a table in SQL Server 2016 Q4528065 KB4528065 January 20, 2021
• 4527716 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server Q4527716 KB4527716 January 20, 2021
• 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 January 20, 2021
• 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 January 20, 2021
• 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 January 20, 2021
• 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 January 20, 2021
• 4525612 FIX: BorderStyle property of TextBox controls may not be rendered in EXCELOPENXML format in SQL Server 2016 Q4525612 KB4525612 January 20, 2021
• 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 January 20, 2021
• 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 January 20, 2021
• 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 January 20, 2021
• 4522134 FIX: Subscriptions fail after you upgrade from SSRS 2012 to SSRS 2016 because of invalid character in mail header Q4522134 KB4522134 January 20, 2021
• 4522127 FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics Q4522127 KB4522127 January 20, 2021
• 4522126 FIX: You may receive wrong results when you query sys.database_scoped_configurations in SQL Server 2016 Q4522126 KB4522126 January 20, 2021
• 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 January 20, 2021
• 4521701 FIX: Cardinality property for a table doesn't include rows in the delta store or deleted bitmap if the table has a clustered columnstore index Q4521701 KB4521701 January 20, 2021
• 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 January 20, 2021
• 4520739 FIX: Access violation error occurs when you try to insert results of stored procedure into a table with dynamic data masking in SQL Server 2016 and 2017 Q4520739 KB4520739 January 20, 2021
• 4520266 FIX: When you change SEEDING_MODE to MANUAL using ALTER AVAILABILITY GROUP, SQL Server 2016 does not cancel the current seeding operations to the secondary replica Q4520266 KB4520266 January 20, 2021
• 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol Q4520124 KB4520124 January 20, 2021
• 4520109 FIX: Access violation occurs when you restore In-Memory OLTP database in SQL Server 2016 Q4520109 KB4520109 January 20, 2021
• 4519847 FIX: MDS Configuration Manager reports SP2 base version in SQL Server 2016 Q4519847 KB4519847 January 20, 2021
• 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 January 20, 2021
• 4519682 FIX: Azure Site Recovery and other VSS jobs may report failures on servers hosting SQL Server 2016 instances Q4519682 KB4519682 January 20, 2021
• 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 and 2017 Q4519679 KB4519679 January 20, 2021
• 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 January 20, 2021
• 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 January 20, 2021
• 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 January 20, 2021
• 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 January 20, 2021
• 4513238 FIX: Error 9003 occurs when you back up a database on a secondary replica in Microsoft SQL Server 2016 and 2017 Q4513238 KB4513238 January 20, 2021
• 4513236 FIX: Internal thread deadlock may occur on primary or secondary replica of availability group in SQL Server 2016 SP2 and 2017 Q4513236 KB4513236 January 20, 2021
• 4513099 FIX: Azure storage I/O subsystem may not reset transfer details for a failed I/O resulting in backup errors Q4513099 KB4513099 January 20, 2021
• 4513097 FIX: Restore or RESTORE VERIFYONLY of a TDE-compressed backup fails in SQL Server 2016 and 2017 Q4513097 KB4513097 January 20, 2021
• 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Q4513096 KB4513096 January 20, 2021
• 4512956 FIX: Querying sys.tables returns temporary tables created by concurrent users starting from SQL Server 2012 Q4512956 KB4512956 January 20, 2021
• 4512821 FIX: Multidimensional mode randomly crashes and an access violation occurs in SQL Server 2016 Q4512821 KB4512821 January 20, 2021
• 4512558 FIX: Assertion error occurs when SQL Server 2016 and 2017 use hash join, hash aggregate, sort or window function in batch-mode plan Q4512558 KB4512558 January 20, 2021
• 4512130 FIX: Data masking may not be applied when you use PIVOT or UNPIVOT function on masked column in SQL Server 2016 and 2017 Q4512130 KB4512130 January 20, 2021
• 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 January 20, 2021
• 4511834 FIX: Memory dumps generate when access violation occurs in SQL Server 2016 Q4511834 KB4511834 January 20, 2021
• 4511816 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016 Q4511816 KB4511816 January 20, 2021
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 January 20, 2021
• 4511751 FIX: Access violation error occurs when SQL Server 2016 and 2017 uses hash join, hash aggregate, sort or window function in batch-mode plan in the deadlock monitor Q4511751 KB4511751 January 20, 2021
• 4511715 FIX: Filled transaction log causes outages when you run Query Store in SQL Server 2016 and 2017 Q4511715 KB4511715 January 20, 2021
• 4510934 FIX: Prolonged non-transactional usage of FileTable without instance restart may cause non-yielding scheduler error or server crash in SQL Server 2014, 2016 and 2017 Q4510934 KB4510934 January 20, 2021
• 4508621 FIX: Data processing is much slower in SSAS 2016 SP2 and 2017 than in SSAS 2016 SP1 Q4508621 KB4508621 January 20, 2021
• 4508472 FIX: Intermittent "row not found" error at Azure SQL DB Subscriber caused by duplication of BEGIN TRAN statements Q4508472 KB4508472 January 20, 2021
• 4505222 Description of the security update for SQL Server 2016 SP2 CU7: July 9, 2019 Q4505222 KB4505222 January 20, 2021
• 4505221 Description of the security update for SQL Server 2016 SP1 CU15: July 9, 2019 Q4505221 KB4505221 January 20, 2021
• 4505220 Description of the security update for SQL Server 2016 SP2 GDR: July 9, 2019 Q4505220 KB4505220 January 20, 2021
• 4505219 Description of the security update for SQL Server 2016 SP1 GDR: July 9, 2019 Q4505219 KB4505219 January 20, 2021
• 4504511 Improvement: Allow altering external data source in APS in SQL Server 2016 Q4504511 KB4504511 January 20, 2021
• 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 January 20, 2021
• 4503385 FIX: DAX query requires more than 200 times of memory than the size of the database in SQL Server 2016 and 2017 multidimensional model database Q4503385 KB4503385 January 20, 2021
• 4502658 FIX: "No valid credentials provided" occurs after you restart PolyBase in SQL Server 2016 and 2017 Q4502658 KB4502658 January 20, 2021
• 4502427 FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016 and 2017 Q4502427 KB4502427 January 20, 2021
• 4502400 FIX: SQL Server 2014, 2016 and 2017 do not perform the requested pre-row assignments when you use MERGE statement that performs assignments of local variables for each row Q4502400 KB4502400 January 20, 2021
• 4501797 FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016 and 2017 Q4501797 KB4501797 January 20, 2021
• 4501741 FIX: URL encoding is incorrect when the Excel workbook name is in Russian language in SSRS 2016 Q4501741 KB4501741 January 20, 2021
• 4501052 Improvement: Enable PDW APS to access TRY_CONVERT() function in SQL Server 2016 Q4501052 KB4501052 January 20, 2021
• 4500770 FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016 and 2017 Q4500770 KB4500770 January 20, 2021
• 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 January 20, 2021
• 4500327 FIX: Non-yielding scheduler issue occurs when you run queries in batch mode that spill in SQL Server 2016 and 2017 Q4500327 KB4500327 January 20, 2021
• 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 January 20, 2021
• 4497701 FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014, 2016 and 2017 Q4497701 KB4497701 January 20, 2021
• 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 January 20, 2021
• 4497225 FIX: Query against table with both clustered columnstore index and nonclustered rowstore index may return incorrect results in SQL Server 2016 and 2017 Q4497225 KB4497225 January 20, 2021
• 4495663 FIX: Error 41162 occurs when the creation of distributed availability groups fails in SQL Server 2016 and 2017 Q4495663 KB4495663 January 20, 2021
• 4495547 FIX: Remote ad hoc queries that use OPENDATASOURCE produce an incorrect error message when the new OLE DB provider is used Q4495547 KB4495547 January 20, 2021
• 4493765 FIX: HTML files cannot be opened directly from the web portal in SSRS 2016 Q4493765 KB4493765 January 20, 2021
• 4493363 FIX: Masked data may be exposed when a query manipulates the data using a temporary table in SQL Server 2016 and 2017 Q4493363 KB4493363 January 20, 2021
• 4492899 FIX: FileTable database level directory is inaccessible after database startup in SQL Server 2016 and 2017 Q4492899 KB4492899 January 20, 2021
• 4492880 FIX: Automatic seeding assertions occur when databases are removed from AG in SQL Server 2016 and 2017 Q4492880 KB4492880 January 20, 2021
• 4492762 FIX: SQL Trace Collection Set fails when you click "Collect and Upload Now" in SQL Server 2016 Q4492762 KB4492762 January 20, 2021
• 4492604 FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016 and 2017 Q4492604 KB4492604 January 20, 2021
• 4491696 FIX: Floating point exception error 3628 occurs when you query DMV sys.dm_db_xtp_hash_index_stats in SQL Server 2016 Q4491696 KB4491696 January 20, 2021
• 4490435 FIX: "The given key was not present in the dictionary" occurs if you do a preview in the CDC Source in SQL Server 2016 Q4490435 KB4490435 January 20, 2021
• 4490237 FIX: Restoring backup to SQL Server 2016 and 2017 from SQL Server 2008 or 2008 R2 takes a long time Q4490237 KB4490237 January 20, 2021
• 4490141 Improvement: DMV sys.dm_hadr_cluster reports cloud witness quorum type "4" and quorum_type_desc "UNKNOWN_QUORUM" in SQL Server 2016 and 2017 Q4490141 KB4490141 January 20, 2021
• 4490136 FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016 and 2017 Q4490136 KB4490136 January 20, 2021
• 4489202 FIX: Error 10314 occurs when you load .NET CLR assembly in SQL Server 2016 and 2017 database Q4489202 KB4489202 January 20, 2021
• 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 January 20, 2021
• 4488971 FIX: MDS database upgrade fails with error in SQL Server 2016 and 2017 Q4488971 KB4488971 January 20, 2021
• 4488949 FIX: Assertion occurs when linked server which points to itself is used in a cross-database transaction in SQL Server 2016 and 2017 Q4488949 KB4488949 January 20, 2021
• 4488856 FIX: Error 2812 and 20028 occur when you drop publisher or enable database for publication after you upgrade your SQL Server 2016 and 2017 Q4488856 KB4488856 January 20, 2021
• 4488853 FIX: 'MSrepl_agent_jobs' does not exist when you run sp_addpullsubscription_agent to create pull subscription in SQL Server 2016 and 2017 Q4488853 KB4488853 January 20, 2021
• 4488817 FIX: FILESTREAM for file I/O access feature can't be enabled when you use Cluster Shared Volumes (CSV) in SQL Server 2016 and 2017 Failover Cluster Instances Q4488817 KB4488817 January 20, 2021
• 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 January 20, 2021
• 4488036 FIX: Repl_Schema_Access wait issues when there are multiple publisher databases on the same instance of SQL Server 2016 and 2017 Q4488036 KB4488036 January 20, 2021
• 4487094 FIX: Delays when Query Store Async Load is enabled in SQL Server 2016 Q4487094 KB4487094 January 20, 2021
• 4486941 Improvement: A way to configure logging for Hadoop bridge in PolyBase in SQL Server 2016 Q4486941 KB4486941 January 20, 2021
• 4486940 FIX: Assertion failure occurs when you try to back up database in limited disk space in SQL Server 2016 and 2017 Q4486940 KB4486940 January 20, 2021
• 4486937 FIX: Publishing MDS data from Excel fails when you save the changes to workbook, close and reopen it in SQL Server 2016 and 2017 Q4486937 KB4486937 January 20, 2021
• 4486935 FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019) Q4486935 KB4486935 January 20, 2021
• 4486932 FIX: Users are incorrectly permitted to create incremental statistics on nonclustered indexes which are not aligned to the base table in SQL Server 2016 and 2017 Q4486932 KB4486932 January 20, 2021
• 4486852 FIX: Access violation when you run a query that contains a batch-mode hash join on Clustered Columnstore Index table in SQL Server 2016 Q4486852 KB4486852 January 20, 2021
• 4483571 FIX: Possible assertion failure when a cross-database transaction involving an Availability Group database is committed from a SQL Server trigger Q4483571 KB4483571 January 20, 2021
• 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 January 20, 2021
• 4480709 FIX: Error 18204 during automatic backup in virtual machines when the backup file is split into multiple files Q4480709 KB4480709 January 20, 2021
• 4480651 Improvement: Merge operation will consider the number of deleted rows in the rowgroup in SQL Server 2016 and 2017 Q4480651 KB4480651 January 20, 2021
• 4480650 FIX: sys.fn_hadr_backup_is_preferred_replica returns TRUE for more than one secondary replica even if the priority values are identical in SQL Server 2016 and 2017 Q4480650 KB4480650 January 20, 2021
• 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object Q4480648 KB4480648 January 20, 2021
• 4480647 Update adds improvements and fixes issues when you use an Oracle RAC environment in SQL Server Q4480647 KB4480647 January 20, 2021
• 4480641 FIX: Columnstore Index build request may time out after 25 seconds though the memory grant time-out is configured in SQL Server 2016 or 2017 Q4480641 KB4480641 January 20, 2021
• 4480640 FIX: Server crashes when you cancel DBCC CHECKDB against a large database in SQL Server 2016 Q4480640 KB4480640 January 20, 2021
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 January 20, 2021
• 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 January 20, 2021
• 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster Q4479283 KB4479283 January 20, 2021
• 4469942 FIX: Sharing violation when the "sp_cycle_agent_errorlog" stored procedure is run in SQL Server Q4469942 KB4469942 January 20, 2021
• 4469908 FIX: Error 3961 occurs when you use Application roles for the second time in read-only secondary replicas in SQL Server 2016 AG Q4469908 KB4469908 January 20, 2021
• 4469349 FIX: VSS backup fails in SQL Server 2008 after you install CU10 for SQL Server 2016 SP1 in the same virtual machine Q4469349 KB4469349 January 20, 2021
• 4469292 FIX: Cannot connect to the MDS database by using the MDS Add-in for Microsoft Excel Q4469292 KB4469292 January 20, 2021
• 4469268 FIX: I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 January 20, 2021
• 4468102 FIX: Excessive memory usage when you trace RPC events that involve Table-Valued Parameters in SQL Server 2016 and 2017 Q4468102 KB4468102 January 20, 2021
• 4468101 Improvement: Optional replacement for "String or binary data would be truncated" message with extended information in SQL Server 2016 and 2017 Q4468101 KB4468101 January 20, 2021
• 4467058 FIX: Query plans are different on clone database created by DBCC CLONEDATABASE and its original database in SQL Server 2014, 2016 and 2017 Q4467058 KB4467058 January 20, 2021
• 4467006 FIX: The schedule changes to "Report-specific schedule" when you enable "Create cache snapshots on a schedule" for the report in SSRS 2016 Q4467006 KB4467006 January 20, 2021
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 January 20, 2021
• 4466831 FIX: “A connection cannot be made” error when SSIS package uses a parameterized connection manager in SQL Server 2016 and 2017 Q4466831 KB4466831 January 20, 2021
• 4466793 FIX: Assertion error occurs when you restart the SQL Server 2016 database Q4466793 KB4466793 January 20, 2021
• 4466108 FIX: Backing up a SQL Server database by using a VSS backup application may fail after installing SQL Server 2016 and 2017 Q4466108 KB4466108 January 20, 2021
• 4466107 FIX: Encryption scan task triggered upon the startup of a database may be canceled in SQL Server 2016 Q4466107 KB4466107 January 20, 2021
• 4465867 FIX: "ran out of memory" error when executing a query on a table that has a large full-text index in SQL Server 2014, 2016 and 2017 Q4465867 KB4465867 January 20, 2021
• 4465249 FIX: “ORA-01036: illegal variable name/number” when you query an Oracle database in SSAS 2016 Q4465249 KB4465249 January 20, 2021
• 4465236 FIX: Access violation occurs in compile code when you parse the forced plan in SQL Server 2016 and 2017 Q4465236 KB4465236 January 20, 2021
• 4463125 FIX: Error occurs when the Database Encryption Key is longer than 3,456 bits in SQL Server 2016 and 2017 Q4463125 KB4463125 January 20, 2021
• 4462481 FIX: Query operation freezes when you insert data into a clustered columnstore index in parallel in SQL Server data warehousing Q4462481 KB4462481 January 20, 2021
• 4460116 FIX: Overestimations when using default Cardinality Estimator to query table with many null values Q4460116 KB4460116 January 20, 2021
• 4459981 FIX: Access violation occurs and SSAS crashes when you process an SSAS database in SQL Server 2014, 2016 and 2017 Q4459981 KB4459981 January 20, 2021
• 4459327 FIX: Error 41317 when you enable server audit and you use in-memory transactions in SQL Server Q4459327 KB4459327 January 20, 2021
• 4458880 FIX: “9003 error, sev 20, state 1” error when a backup operation fails on a secondary replica that is running under asynchronous-commit mode Q4458880 KB4458880 January 20, 2021
• 4458438 FIX: The SQL Service shuts down after SP2 is installed on SQL Server 2016 and 2017 with c2 audit mode enabled Q4458438 KB4458438 January 20, 2021
• 4456883 FIX: Change Tracking cleanup message 22123 is unexpectedly recorded in the error log file in SQL Server Q4456883 KB4456883 January 20, 2021
• 4456775 FIX: Can't retrieve ConnectionID and SPID when running an SSAS Profiler trace in SQL Server Q4456775 KB4456775 January 20, 2021
• 4347088 FIX: Out of memory error occurs even when there are many free pages in SQL Server Q4347088 KB4347088 January 20, 2021
• 4341221 FIX: VSS backup fails in secondary replica of Basic Availability Groups in SQL Server 2016 and 2017 Q4341221 KB4341221 January 20, 2021
• 4339858 FIX: Parallel redo does not work after you disable Trace Flag 3459 in an instance of SQL Server Q4339858 KB4339858 January 20, 2021
• 4338746 FIX: Error 19432 when you use Always On Availability Groups in SQL Server Q4338746 KB4338746 January 20, 2021
• 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 January 20, 2021
• 4338576 FIX: Transaction delays on the primary replica if database synchronization is reported incorrectly on a secondary replica in SQL Server Q4338576 KB4338576 January 20, 2021
• 4338240 FIX: Toggle item, font color, and background color expressions do not work correctly together in SSRS Q4338240 KB4338240 January 20, 2021
• 4338204 FIX: Circular dependency between column names for a calculated table that summarizes the partition query dataset in SQL Server Q4338204 KB4338204 January 20, 2021
• 4316948 FIX: Access violation when you compile a query and histogram amendment is enabled with default Cardinality Estimation in SQL Server 2016 and 2017 Q4316948 KB4316948 January 20, 2021
• 4294694 FIX: Access violation when you try to access a table when page compression is enabled on the table in SQL Server Q4294694 KB4294694 January 20, 2021
• 4230516 FIX: A memory assertion failure occurs, and the server can't make new connections in SQL Server Q4230516 KB4230516 January 20, 2021
• 4163478 FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server Q4163478 KB4163478 January 20, 2021
• 4157948 FIX: Floating point overflow error when you run a nested natively compiled module that uses EXP functions in SQL Server Q4157948 KB4157948 January 20, 2021
• 4133191 FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash Q4133191 KB4133191 January 20, 2021
• 4131251 FIX: Thai characters in SSAS for SQL Server exported to a PDF file are displayed incorrectly Q4131251 KB4131251 January 20, 2021
• 4131193 Performance issues occur in the form of PAGELATCH_EX and PAGELATCH_SH waits in TempDB when you use SQL Server 2016 Q4131193 KB4131193 January 20, 2021
• 4101554 FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error Q4101554 KB4101554 January 20, 2021
• 4101502 FIX: TDE-enabled database backup with compression causes database corruption in SQL Server Q4101502 KB4101502 January 20, 2021
• 4094893 FIX: Database can't be dropped after its storage is disconnected and reconnected in SQL Server Q4094893 KB4094893 January 20, 2021
• 4094858 FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Q4094858 KB4094858 January 20, 2021
• 4093226 FIX: “DirectQuery may not be used with this data source” error when you browse a Direct Query model in SQL Server Q4093226 KB4093226 January 20, 2021
• 4089276 Improves the query performance when an optimized bitmap filter is applied to a query plan in SQL Server 2016 and 2017 Q4089276 KB4089276 January 20, 2021
• 4089099 FIX: It takes a long time to restore a TDE-encrypted database backup in SQL Server Q4089099 KB4089099 January 20, 2021
• 4088901 FIX: Assertion failure when sys.dm_db_log_space_usage statement is run on a database snapshot in SQL Server 2016 and 2017 Q4088901 KB4088901 January 20, 2021
• 4087406 FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017 Q4087406 KB4087406 January 20, 2021
• 4086173 FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Q4086173 KB4086173 January 20, 2021
• 4082865 FIX: SSAS crashes when a query is executed on a large partitioned table in SQL Server 2016 Q4082865 KB4082865 January 20, 2021
• 4077683 FIX: System stored procedure sp_execute_external_script and DMV sys.dm_exec_cached_plans cause memory leaks in SQL Server 2016 and 2017 Q4077683 KB4077683 January 20, 2021
• 4074881 FIX: Assertion error when data is bulk-inserted into a table that contains non-clustered and clustered columnstore indexes in SQL Server 2016 and 2017 Q4074881 KB4074881 January 20, 2021
• 4073393 FIX: "The data area passed to a system call is too small" error when you start a Desktop Bridge application on a SQL Server Q4073393 KB4073393 January 20, 2021
• 4058700 FIX: Intermittent 9004 error when a backup is restored via Standby Mode in SQL Server 2014, 2016, and 2017 Q4058700 KB4058700 January 20, 2021
• 4058565 FIX: Assertion error when executing a stored procedure that references a large object in SQL Server 2014, 2016, and 2017 Q4058565 KB4058565 January 20, 2021
• 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Q4057307 KB4057307 January 20, 2021
• 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Q4053693 KB4053693 January 20, 2021
• 4053293 PolyBase support added for SSL-secured Hadoop clusters and access to Encryption Zones Q4053293 KB4053293 January 20, 2021
• 4052633 FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns bad results in SQL Server Q4052633 KB4052633 January 20, 2021
• 4052625 FIX: Queries that retrieve data by using non-clustered index seek take longer in SQL Server Q4052625 KB4052625 January 20, 2021
• 4052135 FIX: RESTORE HEADERONLY statement for a TDE compressed backup slow to complete in SQL Server Q4052135 KB4052135 January 20, 2021
• 4052127 FIX: Alert Engine reads complete Application event log and sends alerts on old events after Windows is restarted Q4052127 KB4052127 January 20, 2021
• 4051359 FIX: SQL Server runs out of memory when table-valued parameters are captured in Extended Events sessions in SQL Server 2016 even if collecting statement or data stream isn't enabled Q4051359 KB4051359 January 20, 2021
• 4046885 FIX: The SQL Server 2016 setup page contains nonsecure tool-download links Q4046885 KB4046885 January 20, 2021
• 4046858 FIX: Parallel query execution plan with "merge join" slow to execute in Cumulative Update 3, 4, or 5 for SQL Server 2016 Service Pack 1 Q4046858 KB4046858 January 20, 2021
• 4042962 FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 and 2017 Master Data Services Q4042962 KB4042962 January 20, 2021
• 4040539 FIX: Error when using sp_execute_external_script stored procedure to insert data and specify @parallel value to 1 in SQL Server 2016 Q4040539 KB4040539 January 20, 2021
• 4040014 FIX: Query that joins a view and contains UNION ALL slow in SQL Server 2016 Q4040014 KB4040014 January 20, 2021
• 4039735 FIX: "Non-yielding Scheduler" condition occurs for query with many expressions in SQL Server 2014 and 2016 Q4039735 KB4039735 January 20, 2021
• 4025628 FIX: Error 9004 when you try to restore a compressed backup from multiple files for a large TDE-encrypted database in SQL Server Q4025628 KB4025628 January 20, 2021
• 4025021 FIX: Blank spaces in the parameter area when you open SSRS report that contains Hidden or Internal parameters in SQL Server 2016 Q4025021 KB4025021 January 20, 2021
• 4024989 FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error with BULK INSERT statement in SQL Server 2016 Q4024989 KB4024989 January 20, 2021
• 4024392 FIX: "Non-yielding Scheduler" condition occurs when you change the BUCKET_COUNT value for large memory-optimized tables in Microsoft SQL Server 2016 Q4024392 KB4024392 January 20, 2021
• 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 Q4024184 KB4024184 January 20, 2021
• 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 Q4023679 KB4023679 January 20, 2021
• 4023138 FIX: "Incorrect syntax" error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server Q4023138 KB4023138 January 20, 2021
• 4022874 FIX: The FILESTREAM feature in SQL Server is disabled after you install Windows 10 Creators Update Q4022874 KB4022874 January 20, 2021
• 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server Q4021405 KB4021405 January 20, 2021
• 4020747 FIX: SQL Server 2016 crashes with an access violation in sqlmin!TListElem when you execute R scripts Q4020747 KB4020747 January 20, 2021
• 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Q4019983 KB4019983 January 20, 2021
• 4019978 FIX: "Error occurred during rendering" when you export a report as a PowerPoint presentation in SQL Server 2016 Reporting Services Q4019978 KB4019978 January 20, 2021
• 4019863 FIX: Assertion occurs when you run an ALTER TABLE SWITCH statement on a partitioned temporal history table in SQL Server 2016 Q4019863 KB4019863 January 20, 2021
• 4019715 FIX: SQL Server 2016 does not log error messages that have a severity level of 21 for checksum mismatches found in In-Memory OLTP checkpoint files Q4019715 KB4019715 January 20, 2021
• 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Q4019603 KB4019603 January 20, 2021
• 4019446 FIX: SQL Server 2016 stops responding when the "Latch_Suspend_End" extended event is incorrectly triggered Q4019446 KB4019446 January 20, 2021
• 4019286 FIX: SQL Server 2016 Reporting Service subscription incorrectly sends a PDF attachment as an "Application/Octet-Stream" MIME type Q4019286 KB4019286 January 20, 2021
• 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column Q4019125 KB4019125 January 20, 2021
• 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server Q4018227 KB4018227 January 20, 2021
• 4016853 FIX: Deadlock when apps try to acquire or refresh an authentication token through Azure Key Vault Provider for Always Encrypted Q4016853 KB4016853 January 20, 2021
• 4016805 FIX: The SQL Server Analysis Service encounters an internal error when it processes a Tabular model Q4016805 KB4016805 January 20, 2021
• 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Q4016804 KB4016804 January 20, 2021
• 4016238 FIX: DBCC CLONEDATABASE is unsuccessful if the source database has an object originally created in SQL Server 2000 Q4016238 KB4016238 January 20, 2021
• 4014798 Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server Q4014798 KB4014798 January 20, 2021
• 4014719 FIX: "(0x80004002) No such interface supported" error when you use RMO to run Web Synchronization for Merge Replication in SQL Server 2016 Q4014719 KB4014719 January 20, 2021
• 4014706 FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server Q4014706 KB4014706 January 20, 2021
• 4014031 FIX: Incorrect data when a subscription runs on a computer whose time zone differs from the report server time zone in SQL Server 2016 Reporting Services Q4014031 KB4014031 January 20, 2021
• 4014013 FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 Q4014013 KB4014013 January 20, 2021
• 4013877 Update enables DML query plan to scan query memory-optimized tables in parallel in SQL Server 2016 Q4013877 KB4013877 January 20, 2021
• 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Q4013585 KB4013585 January 20, 2021
• 4013207 FIX: "Incorrect syntax for definition of the 'default' constraint" error when you add an arbitrary columnstore column in SQL Server 2016 Q4013207 KB4013207 January 20, 2021
• 4013206 FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance Q4013206 KB4013206 January 20, 2021
• 4013125 Update improves DMV sys.dm_server_services and sys.dm_os_sys_info in SQL Server 2016 Q4013125 KB4013125 January 20, 2021
• 4013124 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 Q4013124 KB4013124 January 20, 2021
• 4013119 FIX: DBCC CLONEDATABASE doesn't copy the runtime cache of the query store to the clone in SQL Server 2016 SP1 Q4013119 KB4013119 January 20, 2021
• 4013118 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 Q4013118 KB4013118 January 20, 2021
• 4013116 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements do not detect a duplicate key in SQL Server 2016 Q4013116 KB4013116 January 20, 2021
• 4013115 FIX: CREATE OR ALTER statement applied on a DDL trigger fails on the next execution in SQL Server 2016 Q4013115 KB4013115 January 20, 2021
• 4013112 FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016 Q4013112 KB4013112 January 20, 2021
• 4013111 FIX: DMV sys.dm_hadr_availability_group_states displays "NOT_HEALTHY" in synchronization_health_desc column on secondary replicas in SQL Server Q4013111 KB4013111 January 20, 2021
• 4011477 FIX: DMF sys.dm_db_incremental_stats_properties doesn't show all partitions if partitioning column is set to character or binary data type Q4011477 KB4011477 January 20, 2021
• 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Q4010990 KB4010990 January 20, 2021
• 4010710 FIX: Memory leak when you run a query that you don’t have sufficient permissions for in SQL Server 2014 or 2016 Q4010710 KB4010710 January 20, 2021
• 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure Q4010162 KB4010162 January 20, 2021
• 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Q4010159 KB4010159 January 20, 2021
• 4009823 FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 or 2016 Q4009823 KB4009823 January 20, 2021
• 4009624 FIX: Audit calls trigger asserts when you create or drop external tables in SQL Server 2016 Q4009624 KB4009624 January 20, 2021
• 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database Q3212318 KB3212318 January 20, 2021
• 3195752 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016 Q3195752 KB3195752 January 20, 2021
• 3093930 "Directory name is invalid" error when you try to install a SQL Server CAB (.exe) package by using Microsoft Edge in Windows 10 Q3093930 KB3093930 January 20, 2021
• 955784 Can't use the Setup program to modify the failover cluster instance in SSAS Q955784 KB955784 January 20, 2021
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 January 20, 2021
• 4583461 Description of the security update for SQL Server 2016 SP2 CU15: January 12, 2021 Q4583461 KB4583461 January 16, 2021
• 4583460 Description of the security update for SQL Server 2016 SP2 GDR: January 12, 2021 Q4583460 KB4583460 January 16, 2021
• 4099490 On-demand hotfix update package for SQL Server 2016 SP1 Q4099490 KB4099490 January 14, 2021
• 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server Q4040401 KB4040401 January 14, 2021
• 4024840 FIX: Access violation occurs when trace flag 176 enabled in SQL Server 2016 Q4024840 KB4024840 January 14, 2021
• 4022435 FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016 Q4022435 KB4022435 January 14, 2021
• 4016850 FIX: Incorrect results when you use SQL Server Management Objects to generate a script for a full-text Search index Q4016850 KB4016850 January 14, 2021
• 4013999 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 Q4013999 KB4013999 January 14, 2021
• 4594205 "Attempted to perform an unauthorized operation" error when you set up or update SQL Server instances Q4594205 KB4594205 January 13, 2021
• 4038456 Msg 104381 when running INSERT...SELECT statement in Analytics Platform System 2016 or later Q4038456 KB4038456 January 13, 2021
• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 January 12, 2021