SQL Server 2017 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 2017 that have been released in January 2021. The list is daily updated.

• 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
• 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
• 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
• 4467273 FIX: Bad plan error occurs and query fails when you use Adaptive Join to run a query in SQL Server 2017 Q4467273 KB4467273 January 26, 2021
• 4465832 FIX: Rebuilding an Index with Resumable Online Index Rebuild can result in a fragmented index in SQL Server 2017 Q4465832 KB4465832 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
• 4462767 FIX: A dump file is generated when you run DBCC CHECKDB on a database that has tables with clustered columnstore index in SQL Server 2017 Q4462767 KB4462767 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
• 4459900 FIX: Synchronization fails when you stop primary replica and fail over a secondary replica to primary in Read-Scale AG in SQL Server 2017 Q4459900 KB4459900 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
• 4459575 FIX: Error occurs when you delete a record in an entity that has "Approval Required" permission enabled in SQL Server 2017 MDS Q4459575 KB4459575 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
• 4346812 FIX: Error occurs when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2017 Q4346812 KB4346812 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
• 4346643 FIX: Errors 3212 and 3013 occur when you backup a database using MIRROR TO DISK option in SQL Server 2017 Q4346643 KB4346643 January 26, 2021
• 4346330 FIX: Delete operation doesn't work in an entity when you enable Approval Required permission in SQL Server 2017 Master Data Services Q4346330 KB4346330 January 26, 2021
• 4345524 FIX: Create and update don’t work in an entity when you set Read and Create permission in MDS 2017 Q4345524 KB4345524 January 26, 2021
• 4345228 FIX: Slow performance in SQL Server 2017 when you run a query that contains HASHBYTES function when compared to SQL Server 2016 Q4345228 KB4345228 January 26, 2021
• 4342424 Improvement: Update to support QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n in USE HINT option in SQL Server 2017 Q4342424 KB4342424 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
• 4340746 FIX: No records are returned when you run an MDX query after restarting SSAS 2016 and 2017 Q4340746 KB4340746 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
• 4131496 Improvement: Enable "forced flush" mechanism in SQL Server 2017 on Linux Q4131496 KB4131496 January 26, 2021
• 4101323 FIX: Errors occur when you upgrade to SQL Server 2017 CU4 or later versions and don't enable SQL Server Agent on Linux Q4101323 KB4101323 January 26, 2021
• 4100918 FIX: SQL Server Agent cannot connect to SQL Server 2017 on Docker when non-default TCP port is used Q4100918 KB4100918 January 26, 2021
• 4100873 FIX: Database Mail cannot connect to SQL Server 2017 on Linux when non-default TCP port is used Q4100873 KB4100873 January 26, 2021
• 4099472 PFS page round robin algorithm improvement in SQL Server 2014, 2016 and 2017 Q4099472 KB4099472 January 26, 2021
• 4099334 FIX: Incorrect user name is displayed when a user logs in MDS and accesses Users and Groups functional area in SQL Server 2017 Q4099334 KB4099334 January 26, 2021
• 4098732 FIX: A calculation error occurs when a secured measure is queried in SSAS 2017 Q4098732 KB4098732 January 26, 2021
• 4096258 FIX: An unexpected exception occurs, SSAS crashes when you run a DAX function in SQL Server 2017 Q4096258 KB4096258 January 26, 2021
• 4092667 FIX: Errors 1921 and 1750 when you create a node or edge table in database that has binary collation in SQL Server 2017 Q4092667 KB4092667 January 26, 2021
• 4091722 FIX: Pacemaker promotes an unsynchronized replica to primary when you use AlwaysOn AG in SQL Server 2017 on Linux Q4091722 KB4091722 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
• 4091063 FIX: Access violation occurs when Query Store collects runtime statistics in SQL Server 2017 Q4091063 KB4091063 January 26, 2021
• 4090789 FIX: In-Memory OLTP database takes a long time to recover in SQL Server 2017 Q4090789 KB4090789 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
• 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
• 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
• 4078301 Improvement: Increase the parallelism of external queries that can be executed by the modern Get Data experience in SSAS 2017 Tabular model Q4078301 KB4078301 January 26, 2021
• 4078288 FIX: PREDICT function does not return error message for missing columns or handle learning parameter for Tree/Forest models in SQL Server 2017 ML Services Q4078288 KB4078288 January 26, 2021
• 4078097 FIX: NEWSEQUENTIALID function generates duplicate GUID after SQL Server 2017 on Linux is restarted Q4078097 KB4078097 January 26, 2021
• 4078096 FIX: SQL Server shuts down after restart if C2 audit mode is enabled Q4078096 KB4078096 January 26, 2021
• 4078095 Improvement: Improves the performance of SQL Server 2017 on smaller systems Q4078095 KB4078095 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
• 4075203 FIX: Memory ramp-up phase is too long after TF 834 is enabled in SQL Server 2017 on Linux Q4075203 KB4075203 January 26, 2021
• 4074661 FIX: Compatibility level of msdb database remains at 130 when you do a slipstream upgrade to SQL Server 2017 Q4074661 KB4074661 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
• 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
• 4057087 FIX: Unable to restore a database by using REPLACE option if the filepath contains redundant path separators in SQL Server 2017 Q4057087 KB4057087 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
• 4056922 FIX: Unnecessary failover when you use AlwaysOn Availability Group in SQL Server 2017 on Linux Q4056922 KB4056922 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
• 4056354 FIX: Mirroring session stops synchronizing after doing rolling upgrade to SQL Server 2017 Q4056354 KB4056354 January 26, 2021
• 4056328 FIX: Performance Counters are missing after the installation of SSAS 2017 in tabular mode Q4056328 KB4056328 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
• 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
• 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
• 4054037 FIX: Fatal error when a natively compiled stored procedure is executed to access memory-optimized tables in SQL Server 2017 Q4054037 KB4054037 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
• 4053439 Improvement: Move master database and error log file to another location in SQL Server 2017 on Linux Q4053439 KB4053439 January 26, 2021
• 4053407 FIX: SQL Server 2017 cannot decrypt data encrypted by earlier versions of SQL Server by using the same symmetric key Q4053407 KB4053407 January 26, 2021
• 4053392 FIX: Name resolution error occurs when IPv6 is disabled on startup in SQL Server 2017 on Linux Q4053392 KB4053392 January 26, 2021
• 4053386 FIX: Using ALTER TABLE on an in-memory optimized table crashes SQL Server 2017 Q4053386 KB4053386 January 26, 2021
• 4053349 FIX: "sys.external_libraries" catalog views are empty for non-dbo users in SQL Server Q4053349 KB4053349 January 26, 2021
• 4053348 FIX: External R library is installed or uninstalled repeatedly in SQL Server Q4053348 KB4053348 January 26, 2021
• 4053329 FIX: Deadlock occurs when multiple PREDICT T-SQL functions run concurrently in SQL Server 2017 Q4053329 KB4053329 January 26, 2021
• 4052984 FIX: Error when you backup database with memory-optimized tables in SQL Server 2017 Q4052984 KB4052984 January 26, 2021
• 4052972 FIX: CT auto cleanup is stuck and not working in SQL Server 2017 Q4052972 KB4052972 January 26, 2021
• 4052969 FIX: Minimum memory limit set to 2GB to install or start SQL Server 2017 Q4052969 KB4052969 January 26, 2021
• 4052938 FIX: DST changes of Sao Paulo time zone are not determined by SQL Server 2017 on Linux Q4052938 KB4052938 January 26, 2021
• 4052697 FIX: TLS cipher suites with PFS don't work for secure connections in SQL Server 2017 on Linux Q4052697 KB4052697 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
• 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
• 4052122 Performance improvement for Spatial Internal Filter in SQL Server 2017 Q4052122 KB4052122 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
• 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
• 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
• 4046044 FIX: Unable to install SQL Server 2017 when instance name/ID/installation path contains multi-byte characters Q4046044 KB4046044 January 26, 2021
• 4046022 FIX: Automatic Tuning settings cannot be configured on ModelDB in SQL Server 2017 Q4046022 KB4046022 January 26, 2021
• 4045678 FIX: Unexpected error when you use the DReplay feature to replay a captured trace in SQL Server 2017 Q4045678 KB4045678 January 26, 2021
• 4045329 Fix: Error when a stored procedure passes a memory-optimized table to an inline table-valued function in SQL Server 2017 Q4045329 KB4045329 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
• 4042885 FIX: Divide-by-zero error when a parallel query is forced to run in serial mode in SQL Server 2017 Q4042885 KB4042885 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
• 4041553 SQL Server Service Packs are discontinued starting from SQL Server 2017 Q4041553 KB4041553 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
• 4037454 FIX: Policy-Based Management policy isn't working after you install CU2 for SQL Server 2016 SP1 Q4037454 KB4037454 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
• 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
• 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
• 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
• 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
• 3156157 Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available Q3156157 KB3156157 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
• 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
• 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Q3010148 KB3010148 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
• 2634571 Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option Q2634571 KB2634571 January 26, 2021
• 4293805 Description of the security update for the remote code execution vulnerability in SQL Server 2017 (CU): August 14, 2018 Q4293805 KB4293805 January 25, 2021
• 4293803 Description of the security update for the Remote Code Execution vulnerability in SQL Server 2017 (GDR): August 14, 2018 Q4293803 KB4293803 January 25, 2021
• 3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later Q3108695 KB3108695 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
• 4578887 FIX: Access violation occurs when you run INSERT EXEC with sp_execute_external_script on a table that has IDENTITY column in SQL Server 2017 Q4578887 KB4578887 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
• 4578110 FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2017 and 2019 Q4578110 KB4578110 January 20, 2021
• 4578012 FIX: Unable to use Filestream on Windows Server 2012 or Windows 8 after applying SQL Server 2017 CU21 Q4578012 KB4578012 January 20, 2021
• 4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 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
• 4575453 FIX: SQL Server does not start when remote admin connections are enabled and IPV6 is disabled on the host Q4575453 KB4575453 January 20, 2021
• 4573172 FIX: Error occurs when you run Distribution Agent on an instance of SQL Server 2017 on Linux Q4573172 KB4573172 January 20, 2021
• 4569425 FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 and 2019 Q4569425 KB4569425 January 20, 2021
• 4569424 FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server Q4569424 KB4569424 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
• 4567837 FIX: Script downgrade may fail when Cumulative Update 20 (CU20) is uninstalled from SQL Server 2017 Q4567837 KB4567837 January 20, 2021
• 4564868 FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2017 and 2019 Q4564868 KB4564868 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
• 4563007 FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 or SQL Server 2017 CU19/CU20/CU21 Q4563007 KB4563007 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
• 4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server Q4551221 KB4551221 January 20, 2021
• 4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server Q4551220 KB4551220 January 20, 2021
• 4548001 FIX: Connection error occurs when you try to connect SQL Server 2017 on Linux by using OpenSSL 1.1 Q4548001 KB4548001 January 20, 2021
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 January 20, 2021
• 4542725 FIX: Core dump may be generated when you restart the SQL Server Q4542725 KB4542725 January 20, 2021
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 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
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 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
• 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
• 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
• 4539023 FIX: Analysis Services Execute DDL task fails to impersonate the user context to the remote Analysis services instance in SQL Server 2017 and 2019 Q4539023 KB4539023 January 20, 2021
• 4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 Q4538849 KB4538849 January 20, 2021
• 4538497 FIX: Slow query performance when using query predicates with UPPER, LOWER or RTRIM with default CE in SQL Server 2017 and 2019 Q4538497 KB4538497 January 20, 2021
• 4538447 FIX: cleanup_server_retention_window does not function correctly when you try to clean up execution logs in SSISDB Q4538447 KB4538447 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
• 4538377 FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 Q4538377 KB4538377 January 20, 2021
• 4538365 FIX: Change Tracking cleanup does not work when invalid cleanup and hardened cleanup version are negative in SQL Server 2017 and 2019 Q4538365 KB4538365 January 20, 2021
• 4538356 FIX: Secondary replica update may fail if availability group configured on Linux in SQL Server 2017 Q4538356 KB4538356 January 20, 2021
• 4538268 FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019 Q4538268 KB4538268 January 20, 2021
• 4538174 FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 and 2019 on Linux Q4538174 KB4538174 January 20, 2021
• 4537649 FIX: Deadlock may occur when you create a database by using non-default collation in SQL Server 2017 Q4537649 KB4537649 January 20, 2021
• 4537438 FIX: Access violation occurs when you join two columns in SQL Server 2017 in which Adaptive joins are permitted Q4537438 KB4537438 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
• 4534893 FIX: Debugging an SSIS package in SSDT 2017 always starts DtsDebugHost in 32-bit instead of 64-bit Q4534893 KB4534893 January 20, 2021
• 4532751 Improvement: Snapshot replication and transactional replication are enabled on Linux in SQL Server 2017 Q4532751 KB4532751 January 20, 2021
• 4531736 FIX: SQLDiag fails to generate output due to missing stored procedure tempdb.dbo.sp_sqldiag14 in SQL Server 2017 and 2019 Q4531736 KB4531736 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
• 4531009 FIX: An access violation may occur when the optimizer uses an Adaptive Join in SQL Server 2017 Q4531009 KB4531009 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
• 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 Q4530302 KB4530302 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
• 4529927 FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017 Q4529927 KB4529927 January 20, 2021
• 4529833 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 Q4529833 KB4529833 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
• 4527916 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 Q4527916 KB4527916 January 20, 2021
• 4527842 FIX: SQL Server 2017 generates dump when you transfer ownership of full-text stoplist to another user if previous owner is dropped Q4527842 KB4527842 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
• 4527538 FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument Q4527538 KB4527538 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
• 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
• 4524191 FIX: Menu and scroll bar are missing in "Changes" section when large number of changesets are added in Excel add-in for MDS in SQL Server 2017 and 2019 Q4524191 KB4524191 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
• 4522911 FIX: Synchronize command copies SSAS 2017 tabular model database role membership even when Skipmembership is used Q4522911 KB4522911 January 20, 2021
• 4522909 FIX: Error occurs when you refresh data on Power BI after Process FULL of SSAS 2017 Tabular database Q4522909 KB4522909 January 20, 2021
• 4522404 FIX: Error 8965 occurs when you run DBCC CHECKDB with PHYSICAL_ONLY option on CCI table in SQL Server 2017 Q4522404 KB4522404 January 20, 2021
• 4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error Q4522002 KB4522002 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
• 4521758 FIX: JDBC XA transaction fails with an error in SQL Server 2017 on Linux Q4521758 KB4521758 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
• 4520438 FIX: Accessibility bugs are fixed in MDS 2019 but not fixed in MDS 2017 Q4520438 KB4520438 January 20, 2021
• 4520149 FIX: Assertion occurs when you fail over Read-Scale AlwaysOn Availability Groups in SQL Server 2017 Q4520149 KB4520149 January 20, 2021
• 4520148 FIX: Error 35262 with Severity 17 occurs when database is part of an Availability Group in SQL Server 2017 Q4520148 KB4520148 January 20, 2021
• 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol Q4520124 KB4520124 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
• 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
• 4517404 FIX: Unexpected results occur when you query a SSAS 2017 tabular mode database in DQ mode Q4517404 KB4517404 January 20, 2021
• 4516999 FIX: File content is sent twice when copied to HDFS using Hadoop File System Task in SQL Server 2017 and 2019 Q4516999 KB4516999 January 20, 2021
• 4515773 FIX: Hadoop File System Task fails to copy gigabyte-large file from HDFS in SQL Server 2017 Q4515773 KB4515773 January 20, 2021
• 4514829 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2017 Q4514829 KB4514829 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
• 4513235 FIX: Database is inaccessible when you upgrade tabular model compatibility level from 1103 to 1400 in SQL Server 2017 Q4513235 KB4513235 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
• 4513095 FIX: Access violation occurs when you start the Full-Text service in Linux in SQL Server 2017 Q4513095 KB4513095 January 20, 2021
• 4512979 FIX: SQL Server 2017 on Linux fails in script upgrade mode for the database SSISDB after you apply CU9 Q4512979 KB4512979 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
• 4512820 Improvement: Microsoft Distributed Transaction Coordinator is enabled on Linux in SQL Server 2017 Q4512820 KB4512820 January 20, 2021
• 4512603 FIX: SSAS 2017 crashes intermittently due to c0000005 Access violation error Q4512603 KB4512603 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
• 4512210 FIX: SQL Server 2017 on Linux fails with last chance exception error Q4512210 KB4512210 January 20, 2021
• 4512150 FIX: Extended Event sql_statement_post_compile does not populate object_name field in SQL Server 2017 Q4512150 KB4512150 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
• 4512026 FIX: Access violation occurs when you insert LOB data in Clustered Columnstore Index in SQL Server 2017 Q4512026 KB4512026 January 20, 2021
• 4511885 FIX: Resolving state occurs when an assertion occurs in SQL Server 2017 Q4511885 KB4511885 January 20, 2021
• 4511884 FIX: Error occurs when a non-dbo user alters procedure in SQL Server 2017 database that has Merge Publication enabled Q4511884 KB4511884 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
• 4509084 FIX: Unexpected index will be deleted when you delete attribute including index in SQL Server 2017 Q4509084 KB4509084 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
• 4508065 FIX: Login to SQL Server 2017 on Linux takes more time with SQL authentication than SQL Server 2017 on Windows Q4508065 KB4508065 January 20, 2021
• 4505820 FIX: SQLCLR function takes a longer time to run the query in CU 14 than RTM of SQL Server 2017 Q4505820 KB4505820 January 20, 2021
• 4505726 FIX: Dynamic Data Masking does not function as expected in SQL Server 2017 Q4505726 KB4505726 January 20, 2021
• 4505225 Description of the security update for SQL Server 2017 CU15: July 9, 2019 Q4505225 KB4505225 January 20, 2021
• 4505224 Description of the security update for SQL Server 2017 GDR: July 9, 2019 Q4505224 KB4505224 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
• 4503386 FIX: Exception occurs when you design a parameterized DAX query in Query Designer of Report Builder in SSRS Q4503386 KB4503386 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
• 4503379 FIX: Referential integrity constraints are not evaluated correctly when query execution plan uses Foreign Key Reference Check operator in SQL Server 2016 and 2017 Q4503379 KB4503379 January 20, 2021
• 4502706 FIX: SQL Server generates core dump with "Failed to monitor external signals" in SQL Server 2017 Q4502706 KB4502706 January 20, 2021
• 4502659 FIX: PolyBase queries that target Parquet or ORC files in HDP 3.0 or later will fail with pushdown computation enabled Q4502659 KB4502659 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
• 4502442 FIX: sys.fn_hadr_backup_is_preferred_replica causes error 41005 in SQL Server 2017 Q4502442 KB4502442 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
• 4502380 FIX: SQL Server 2017 crashes because of stack overflow when you try to back up database master to disk Q4502380 KB4502380 January 20, 2021
• 4502376 FIX: Access violation occurs in sqlmin!AGHealthCompStateActual::GetData in SQL Server 2017 Q4502376 KB4502376 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
• 4501670 FIX: CPU and elapsed time reported by query_plan_profile and query_post_execuion_plan_profile XEvents are not accurate in SQL Server 2017 Q4501670 KB4501670 January 20, 2021
• 4500783 FIX: Interleaved execution on MSTVFs by using memory-optimized tables causes floating point exception in SQL Server 2017 Q4500783 KB4500783 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
• 4500595 FIX: CDC Source preview fails with "The given key was not present in the dictionary" error in SQL Server 2017 Q4500595 KB4500595 January 20, 2021
• 4500574 FIX: Self-deadlock occurs when transaction auditing is enabled in SQL Server 2016 and 2017 Q4500574 KB4500574 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
• 4499614 FIX: Access Violation occurs due to corruption of compressed Showplan.xml file in SQL Server 2017 Q4499614 KB4499614 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
• 4498924 FIX: Gray background for read-only attributes disappears after Refresh in Excel Add-in for MDS in SQL Server 2017 Q4498924 KB4498924 January 20, 2021
• 4498720 FIX: Core dump failed to generate on m_numLocks.load() == 0 error in SQL Server 2017 Q4498720 KB4498720 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
• 4497700 Restricted data is not protected correctly by OLS in SQL Server 2017 Analysis Services Q4497700 KB4497700 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
• 4495683 FIX: Search Attribute doesn't work when display format is set to "Name {Code}" in SQL Server 2017 Q4495683 KB4495683 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
• 4494650 FIX: Access violation occurs when you run a batch-mode query with UNION statement in SQL Server 2017 Q4494650 KB4494650 January 20, 2021
• 4494352 Description of the security update for SQL Server 2017 CU 14 GDR: May 14, 2019 Q4494352 KB4494352 January 20, 2021
• 4494351 Description of the security update for SQL Server 2017 GDR: May 14, 2019 Q4494351 KB4494351 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
• 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
• 4490478 FIX: AD authentication fails to connect to SQL Server 2017 Q4490478 KB4490478 January 20, 2021
• 4490379 FIX: TCP Timeout or login time-out error occurs when you connect to SQL Server 2017 by using Integrated Authentication Q4490379 KB4490379 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
• 4490145 Improvement: New mssql-conf option network.enablekdcfromkrb5 is added in SQL Server 2017 Q4490145 KB4490145 January 20, 2021
• 4490142 FIX: Truncation error when TF 460 is enabled and you use INSERT INTO table variable in ELSE block in SQL Server 2017 Q4490142 KB4490142 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
• 4490137 FIX: TCP Timeout or login time-out error occurs when you connect to SQL Server 2017 using Integrated Authentication Q4490137 KB4490137 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
• 4490135 FIX: SQL Server 2017 may crash when local process uses global key event handle Q4490135 KB4490135 January 20, 2021
• 4490134 Improvement: Add a new extended event query_post_execution_plan_profile in SQL Server 2017 Q4490134 KB4490134 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
• 4488400 FIX: Access violation occurs and data movement is suspended for databases in Availability Group in SQL Server 2017 Q4488400 KB4488400 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
• 4487975 FIX: Reporting Action feature does not appear in the menu when you view the related measure in Excel or use MDSCHEMA_ACTIONS in SSAS 2017 Q4487975 KB4487975 January 20, 2021
• 4487751 FIX: An unexpected exception error occurs when you run a TREATAS function DAX query from Power BI desktop in SSAS 2017 Q4487751 KB4487751 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
• 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
• 4480645 FIX: Access violation when you query by using “sys.dm_db_tuning_recommendations” in SQL Server Q4480645 KB4480645 January 20, 2021
• 4480644 FIX: A dump file may be generated when you run the DML internal plan on Query Store enabled database in SQL Server 2017 Q4480644 KB4480644 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
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 January 20, 2021
• 4480634 Improvement: IsAvailableInMDX feature can disable processing for specific columns in TREATAS function DAX query in SQL Server 2017 Q4480634 KB4480634 January 20, 2021
• 4480631 FIX: DCExec crashes when you collect data in SQL Server 2017 Q4480631 KB4480631 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
• 4471213 FIX: Primary replica databases display "NOT SYNCHRONIZING" status when all replicas in AG use synchronous commit availability mode in SQL Server 2017 Q4471213 KB4471213 January 20, 2021
• 4470821 FIX: DBCC CHECKDB on master database fails with error 2570 when Common Criteria Compliance is enabled in SQL Server 2017 Q4470821 KB4470821 January 20, 2021
• 4470411 FIX: Designing a parameterized DAX query in Report Builder Query Designer generates an exception in SSAS Q4470411 KB4470411 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
• 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
• 4469140 FIX: "Could not find server" when the publisher database name contains a period in SQL Server 2017 Q4469140 KB4469140 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
• 4467449 FIX: Pacemaker can't manage cluster resources in an Always On Availability Group in SQL Server Q4467449 KB4467449 January 20, 2021
• 4467074 Update disables trace flag 2467 at session level to prevent a performance issue for parallel queries in SQL Server 2017 Q4467074 KB4467074 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
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 January 20, 2021
• 4466962 FIX: SQL Server 2017 crashes when you use third-party Active Directory providers Q4466962 KB4466962 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
• 4466491 Improvement: You can set the minimum interval value to less than 10 seconds for running SSIS packages in parallel in SQL Server 2017 Q4466491 KB4466491 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
• 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
• 4465248 FIX: “An unexpected exception occurred” in an MDX query for PC dimensions in SSAS 2017 Q4465248 KB4465248 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
• 4465204 FIX: An intra-query deadlock occurs in a query containing UNION ALL in batch mode in SQL Server Q4465204 KB4465204 January 20, 2021
• 4463757 FIX: "Encryption not supported on the client" error when a SQL Server 2017 linked server query fails Q4463757 KB4463757 January 20, 2021
• 4463314 Update improves SQL server performance by restricting which KDC can be contacted in geographically large networks Q4463314 KB4463314 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
• 4462699 FIX: Derived hierarchies not working in SQL Server 2017 MDS Add-in for Microsoft Excel Q4462699 KB4462699 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
• 4347055 FIX: Out of memory error when you run SQL Server 2017 in a Linux Docker container Q4347055 KB4347055 January 20, 2021
• 4345683 FIX: A value set for the “Accepted NTLM SPNs” variable causes an access violation during startup of SQL Server 2017 Q4345683 KB4345683 January 20, 2021
• 4345402 FIX: Synchronization of a database takes a long time to finish in SQL Server 2017 Q4345402 KB4345402 January 20, 2021
• 4344904 Improvement enables CREATE AVAILABILITY GROUP and ALTER AVAILABILITY GROUP DDLs to set the SESSION_TIMEOUT for a configuration-only replica in SQL Server Q4344904 KB4344904 January 20, 2021
• 4344103 FIX: MEMORYCLERK_SOSMEMMANAGER grows larger and FAIL_PAGE_ALLOCATION error is logged after you enable large page allocations Q4344103 KB4344103 January 20, 2021
• 4342111 Update adds improved support for SAP HANA data sources in SQL Server Analysis Services Q4342111 KB4342111 January 20, 2021
• 4341264 Improvement: SQL Server Agent jobs can start without waiting for all databases to recover in SQL Server 2017 on Linux Q4341264 KB4341264 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
• 4341219 FIX: A split-brain scenario occurs after a failover when using AlwaysOn Availability Groups with external cluster technology in SQL Server 2017 Q4341219 KB4341219 January 20, 2021
• 4340747 FIX: SQLDUMPER.EXE-initiated dumps take a long time to finish in SQL Server 2017 on Linux Q4340747 KB4340747 January 20, 2021
• 4340069 FIX: SQL Server 2017 on Linux shuts down unexpectedly during the recovery of an In-Memory OLTP database Q4340069 KB4340069 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
• 4339664 FIX: Exception error occurs when you try to refresh data for a pivot table in Excel in SSAS 2017 Q4339664 KB4339664 January 20, 2021
• 4339613 FIX: “Unclosed quotation mark after the character string” error in the MDS explorer when you try to add a new member to an entity in SQL Server Q4339613 KB4339613 January 20, 2021
• 4339090 Improvement to reduce the fail-over duration for an availability group in SQL Server on Linux Q4339090 KB4339090 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
• 4338337 FIX: SQL Server crashes and then restarts when the “Adaptive join” option is enabled Q4338337 KB4338337 January 20, 2021
• 4338330 FIX: CASE expressions containing identical sub-queries may return incorrect results in SQL Server 2017 Q4338330 KB4338330 January 20, 2021
• 4337645 FIX: Error 883 occurs when a database that belongs to an availability group is marked as SUSPECT in SQL Server 2017 on Linux Q4337645 KB4337645 January 20, 2021
• 4336873 FIX: A LOB allocator may be leaked when a LOB or off-row column is altered or dropped in SQL Server 2017 Q4336873 KB4336873 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
• 4316793 FIX: Unnecessary failovers occur when a SQL Server 2017 Failover Cluster Instance or Always On AG is managed by Pacemaker Q4316793 KB4316793 January 20, 2021
• 4316791 FIX: Two SQL Server instances are the primary replica of an availability group in SQL Server Q4316791 KB4316791 January 20, 2021
• 4316790 FIX: Startup of a database that belongs to an availability group times out in SQL Server on Linux Q4316790 KB4316790 January 20, 2021
• 4316789 FIX: Always On database is stuck at “Recovery Pending” after the host name of an availability replica is renamed in SQL Server Q4316789 KB4316789 January 20, 2021
• 4316655 FIX: An assertion error occurs when querying dm_db_stats_histogram DMF in SQL Server 2017 Q4316655 KB4316655 January 20, 2021
• 4295097 FIX: Cannot change the “isAvailableInMdx” column property to “False” in SSAS in Tabular mode Q4295097 KB4295097 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
• 4293761 FIX: Unexpected error when processing a table by using the “Process Full” option in SQL Server Analysis Services Q4293761 KB4293761 January 20, 2021
• 4293576 FIX: "Non-yielding" error when you try to recover an In-Memory database in SQL Server Q4293576 KB4293576 January 20, 2021
• 4230542 FIX: Pacemaker promotion of local replica to primary fails when using AlwaysOn AG in SQL Server 2017 Q4230542 KB4230542 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
• 4230465 FIX: Communication link error when you use datetime2 fields while accessing a database in SQL Server 2017 Q4230465 KB4230465 January 20, 2021
• 4212960 FIX: SQL Server will not start when you run a SQL Server 2017 Linux container image on Docker for Windows Q4212960 KB4212960 January 20, 2021
• 4163528 FIX: DAX query performance decrease after you upgrade to SQL Server 2017 Q4163528 KB4163528 January 20, 2021
• 4163526 FIX: A DAX query that contains SWITCH and nested IF statements takes more than an hour to finish in SQL Server Q4163526 KB4163526 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
• 4136912 Multiple device VDI backup can hang on Linux Q4136912 KB4136912 January 20, 2021
• 4136679 FIX: SQL Server 2017 Analysis Services crashes after a random query is run against DirectQuery mode Q4136679 KB4136679 January 20, 2021
• 4133191 FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash Q4133191 KB4133191 January 20, 2021
• 4132042 FIX: Query performance difference between SSAS 2014 and SSAS 2017 Q4132042 KB4132042 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
• 4101482 FIX: Automatic seeding fails when using an Always On availability group in SQL Server Q4101482 KB4101482 January 20, 2021
• 4099126 FIX: "Access Violation" error when you execute a complex query with multiple joins and the Adaptive Join feature is enabled in SQL Server Q4099126 KB4099126 January 20, 2021
• 4098763 FIX: R script fails on parallel execution in SQL Server 2017 Q4098763 KB4098763 January 20, 2021
• 4096875 FIX: "Access is denied" error when you try to create a database in SQL Server 2017 Express LocalDB Q4096875 KB4096875 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
• 4093805 FIX: Can't stop the SQL Server Linux Docker container by using the “docker stop” command Q4093805 KB4093805 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
• 4089946 FIX: SQL Server stops responding when you remove the availability group listener or change their port number Q4089946 KB4089946 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
• 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
• 4088270 FIX: Big PAGELATCH_EX contentions when you remove temporary objects in SQL Server Q4088270 KB4088270 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
• 4078303 FIX: Access violation in SSAS when MDX query is executed in SQL Server 2017 Q4078303 KB4078303 January 20, 2021
• 4078098 FIX: Database schemas aren't upgraded or downgraded when you install or uninstall a cumulative update in SQL Server 2017 on Linux Q4078098 KB4078098 January 20, 2021
• 4077899 FIX: PolyBase not installed with SQL Server 2017 because installer doesn't recognize JRE 9 Q4077899 KB4077899 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
• 4076982 FIX: Pacemaker demotes existing primary replica of an AlwaysOn AG in SQL Server 2017 on Linux and never promotes a new one Q4076982 KB4076982 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
• 4073684 FIX: Change data capture does not work in SQL Server 2017 Q4073684 KB4073684 January 20, 2021
• 4073670 FIX: Can't create a login based on a user that belongs to the parent domain in SQL Server 2017 on Linux Q4073670 KB4073670 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
• 4073045 FIX: Unexpected memory consumption when TCP protocol connections are used for SQL Server 2017 on Linux Q4073045 KB4073045 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
• 4056154 Update adds execution statistics for scalar-valued, user-defined functions to the actual Showplan XML in SQL Server 2017 Q4056154 KB4056154 January 20, 2021
• 4054036 FIX: Error 8624 when you run a query that contains a SELECT DISTINCT statement on a graph column in SQL Server 2017 on Linux or Windows Q4054036 KB4054036 January 20, 2021
• 4054035 FIX: Error 213 when you merge or split a partition of a partitioned graph table in SQL Server 2017 on Linux or Windows Q4054035 KB4054035 January 20, 2021
• 4053447 FIX: Incorrect prompt to restart SQL Server 2017 on Linux when not required Q4053447 KB4053447 January 20, 2021
• 4053393 FIX: SQL Server 2017 on Linux doesn't listen to nondefault IP address specified by mssql-conf script Q4053393 KB4053393 January 20, 2021
• 4053293 PolyBase support added for SSL-secured Hadoop clusters and access to Encryption Zones Q4053293 KB4053293 January 20, 2021
• 4053291 FIX: "sys.dm_exec_query_profiles" DMV returns wrong "estimate_row_count" in SQL Server 2017 on Linux and Windows Q4053291 KB4053291 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
• 4052338 FIX: Excessive PREMPTIVE_OS_CREATEDIRECTORY waits during workload that compiles or recompiles memory-optimized tables or table types Q4052338 KB4052338 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
• 4052126 Update adds new "marked_transaction_latch_trace" extended event in SQL Server 2017 on Linux and Windows Q4052126 KB4052126 January 20, 2021
• 4046744 FIX: DML statements that use cascading operations fail in SQL Server 2017 Q4046744 KB4046744 January 20, 2021
• 4046638 Add the ability to disable or enable a few new DMVs and DMFs introduced in SQL Server 2017 Q4046638 KB4046638 January 20, 2021
• 4046102 FIX: State of the ForceLastGoodPlan recommendation is falsely reported as Expired if applied manually in SQL Server 2017 Q4046102 KB4046102 January 20, 2021
• 4046099 FIX: Assertion error after creating snapshot backup for database with memory-optimized tables in SQL Server 2017 Q4046099 KB4046099 January 20, 2021
• 4046066 All transactions reported as completed even though some fail while trying to commit in SQL Server 2017 Q4046066 KB4046066 January 20, 2021
• 4045814 FIX: "Message 611" error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index Q4045814 KB4045814 January 20, 2021
• 4045687 Update to enable SQL Server 2017 Express edition to act as a witness role in a database mirroring session Q4045687 KB4045687 January 20, 2021
• 4044009 FIX: A deadlock condition occurs when you create a new database in SQL Server 2017 Q4044009 KB4044009 January 20, 2021
• 4043455 FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 Q4043455 KB4043455 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
• 4010460 FIX: .NET Framework error when you update the reference table of a Fuzzy Lookup transformation in SSIS Q4010460 KB4010460 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
• 4583457 Description of the security update for SQL Server 2017 CU22: January 12, 2021 Q4583457 KB4583457 January 16, 2021
• 4583456 Description of the security update for SQL Server 2017 GDR: January 12, 2021 Q4583456 KB4583456 January 16, 2021
• 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server Q4040401 KB4040401 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