SQL Server 2017 articles, fixes and updates - Year 2020

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 Year 2020. The list is daily updated.

• 4038932 FIX: Change Data Capture functionality does not work in SQL Server Q4038932 KB4038932 December 24, 2020
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
• 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 December 17, 2020
• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
• 955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure Q955644 KB955644 November 8, 2020
• 4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 October 24, 2020
• 4533057 "Query optimizer generated too many subcubes" error and MDX query fails in SSAS multidimensional instance Q4533057 KB4533057 October 24, 2020
• 4519691 SQL database restore operation fails on Linux servers Q4519691 KB4519691 October 24, 2020
• 4488257 Inconsistent results in MKL computations because of a missing environment variable in Microsoft R Server or Machine Learning Server Q4488257 KB4488257 October 24, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4578110 FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2017 and 2019 Q4578110 KB4578110 October 23, 2020
• 4578012 FIX: Unable to use Filestream on Windows Server 2012 or Windows 8 after applying SQL Server 2017 CU21 Q4578012 KB4578012 October 23, 2020
• 4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 October 23, 2020
• 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 October 23, 2020
• 4575453 FIX: SQL Server does not start when remote admin connections are enabled and IPV6 is disabled on the host Q4575453 KB4575453 October 23, 2020
• 4573172 FIX: Error occurs when you run Distribution Agent on an instance of SQL Server 2017 on Linux Q4573172 KB4573172 October 23, 2020
• 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 October 23, 2020
• 4569424 FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server Q4569424 KB4569424 October 23, 2020
• 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 October 23, 2020
• 4567837 FIX: Script downgrade may fail when Cumulative Update 20 (CU20) is uninstalled from SQL Server 2017 Q4567837 KB4567837 October 23, 2020
• 4564868 FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2017 and 2019 Q4564868 KB4564868 October 23, 2020
• 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 October 23, 2020
• 4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 October 23, 2020
• 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 October 23, 2020
• 4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server Q4551221 KB4551221 October 23, 2020
• 4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server Q4551220 KB4551220 October 23, 2020
• 4548001 FIX: Connection error occurs when you try to connect SQL Server 2017 on Linux by using OpenSSL 1.1 Q4548001 KB4548001 October 23, 2020
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 October 23, 2020
• 4542725 FIX: Core dump may be generated when you restart the SQL Server Q4542725 KB4542725 October 23, 2020
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 October 23, 2020
• 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 October 23, 2020
• 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 October 23, 2020
• 4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 October 23, 2020
• 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 October 23, 2020
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 October 23, 2020
• 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 October 23, 2020
• 4540903 FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016, 2017 and 2019 Q4540903 KB4540903 October 23, 2020
• 4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 October 23, 2020
• 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 October 23, 2020
• 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 October 23, 2020
• 4540107 FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016, 2017 and 2019 Q4540107 KB4540107 October 23, 2020
• 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 October 23, 2020
• 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 October 23, 2020
• 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 October 23, 2020
• 4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 Q4538849 KB4538849 October 23, 2020
• 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 October 23, 2020
• 4538447 FIX: cleanup_server_retention_window does not function correctly when you try to clean up execution logs in SSISDB Q4538447 KB4538447 October 23, 2020
• 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 October 23, 2020
• 4538377 FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 Q4538377 KB4538377 October 23, 2020
• 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 October 23, 2020
• 4538356 FIX: Secondary replica update may fail if availability group configured on Linux in SQL Server 2017 Q4538356 KB4538356 October 23, 2020
• 4538268 FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019 Q4538268 KB4538268 October 23, 2020
• 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 October 23, 2020
• 4537649 FIX: Deadlock may occur when you create a database by using non-default collation in SQL Server 2017 Q4537649 KB4537649 October 23, 2020
• 4537438 FIX: Access violation occurs when you join two columns in SQL Server 2017 in which Adaptive joins are permitted Q4537438 KB4537438 October 23, 2020
• 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 October 23, 2020
• 4534893 FIX: Debugging an SSIS package in SSDT 2017 always starts DtsDebugHost in 32-bit instead of 64-bit Q4534893 KB4534893 October 23, 2020
• 4532751 Improvement: Snapshot replication and transactional replication are enabled on Linux in SQL Server 2017 Q4532751 KB4532751 October 23, 2020
• 4531736 FIX: SQLDiag fails to generate output due to missing stored procedure tempdb.dbo.sp_sqldiag14 in SQL Server 2017 and 2019 Q4531736 KB4531736 October 23, 2020
• 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 October 23, 2020
• 4531009 FIX: An access violation may occur when the optimizer uses an Adaptive Join in SQL Server 2017 Q4531009 KB4531009 October 23, 2020
• 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 October 23, 2020
• 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 October 23, 2020
• 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 October 23, 2020
• 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 October 23, 2020
• 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 Q4530302 KB4530302 October 23, 2020
• 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 October 23, 2020
• 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 October 23, 2020
• 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 October 23, 2020
• 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 October 23, 2020
• 4529927 FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017 Q4529927 KB4529927 October 23, 2020
• 4529833 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 Q4529833 KB4529833 October 23, 2020
• 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 October 23, 2020
• 4528130 FIX: Access violation occurs when you restore the In-Memory Optimized database in SQL Server 2016 and 2017 Q4528130 KB4528130 October 23, 2020
• 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 October 23, 2020
• 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 October 23, 2020
• 4527916 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 Q4527916 KB4527916 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 October 23, 2020
• 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 October 23, 2020
• 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 October 23, 2020
• 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 October 23, 2020
• 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 October 23, 2020
• 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 October 23, 2020
• 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 October 23, 2020
• 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 October 23, 2020
• 4522911 FIX: Synchronize command copies SSAS 2017 tabular model database role membership even when Skipmembership is used Q4522911 KB4522911 October 23, 2020
• 4522909 FIX: Error occurs when you refresh data on Power BI after Process FULL of SSAS 2017 Tabular database Q4522909 KB4522909 October 23, 2020
• 4522404 FIX: Error 8965 occurs when you run DBCC CHECKDB with PHYSICAL_ONLY option on CCI table in SQL Server 2017 Q4522404 KB4522404 October 23, 2020
• 4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error Q4522002 KB4522002 October 23, 2020
• 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 October 23, 2020
• 4521758 FIX: JDBC XA transaction fails with an error in SQL Server 2017 on Linux Q4521758 KB4521758 October 23, 2020
• 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 October 23, 2020
• 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 October 23, 2020
• 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 October 23, 2020
• 4520438 FIX: Accessibility bugs are fixed in MDS 2019 but not fixed in MDS 2017 Q4520438 KB4520438 October 23, 2020
• 4520149 FIX: Assertion occurs when you fail over Read-Scale AlwaysOn Availability Groups in SQL Server 2017 Q4520149 KB4520149 October 23, 2020
• 4520148 FIX: Error 35262 with Severity 17 occurs when database is part of an Availability Group in SQL Server 2017 Q4520148 KB4520148 October 23, 2020
• 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol Q4520124 KB4520124 October 23, 2020
• 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 October 23, 2020
• 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 and 2017 Q4519679 KB4519679 October 23, 2020
• 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 October 23, 2020
• 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 October 23, 2020
• 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 October 23, 2020
• 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 October 23, 2020
• 4517404 FIX: Unexpected results occur when you query a SSAS 2017 tabular mode database in DQ mode Q4517404 KB4517404 October 23, 2020
• 4516999 FIX: File content is sent twice when copied to HDFS using Hadoop File System Task in SQL Server 2017 and 2019 Q4516999 KB4516999 October 23, 2020
• 4515773 FIX: Hadoop File System Task fails to copy gigabyte-large file from HDFS in SQL Server 2017 Q4515773 KB4515773 October 23, 2020
• 4514829 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2017 Q4514829 KB4514829 October 23, 2020
• 4513238 FIX: Error 9003 occurs when you back up a database on a secondary replica in Microsoft SQL Server 2016 and 2017 Q4513238 KB4513238 October 23, 2020
• 4513236 FIX: Internal thread deadlock may occur on primary or secondary replica of availability group in SQL Server 2016 SP2 and 2017 Q4513236 KB4513236 October 23, 2020
• 4513235 FIX: Database is inaccessible when you upgrade tabular model compatibility level from 1103 to 1400 in SQL Server 2017 Q4513235 KB4513235 October 23, 2020
• 4513099 FIX: Azure storage I/O subsystem may not reset transfer details for a failed I/O resulting in backup errors Q4513099 KB4513099 October 23, 2020
• 4513097 FIX: Restore or RESTORE VERIFYONLY of a TDE-compressed backup fails in SQL Server 2016 and 2017 Q4513097 KB4513097 October 23, 2020
• 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Q4513096 KB4513096 October 23, 2020
• 4513095 FIX: Access violation occurs when you start the Full-Text service in Linux in SQL Server 2017 Q4513095 KB4513095 October 23, 2020
• 4512979 FIX: SQL Server 2017 on Linux fails in script upgrade mode for the database SSISDB after you apply CU9 Q4512979 KB4512979 October 23, 2020
• 4512956 FIX: Querying sys.tables returns temporary tables created by concurrent users starting from SQL Server 2012 Q4512956 KB4512956 October 23, 2020
• 4512820 Improvement: Microsoft Distributed Transaction Coordinator is enabled on Linux in SQL Server 2017 Q4512820 KB4512820 October 23, 2020
• 4512603 FIX: SSAS 2017 crashes intermittently due to c0000005 Access violation error Q4512603 KB4512603 October 23, 2020
• 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 October 23, 2020
• 4512210 FIX: SQL Server 2017 on Linux fails with last chance exception error Q4512210 KB4512210 October 23, 2020
• 4512150 FIX: Extended Event sql_statement_post_compile does not populate object_name field in SQL Server 2017 Q4512150 KB4512150 October 23, 2020
• 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 October 23, 2020
• 4512026 FIX: Access violation occurs when you insert LOB data in Clustered Columnstore Index in SQL Server 2017 Q4512026 KB4512026 October 23, 2020
• 4511885 FIX: Resolving state occurs when an assertion occurs in SQL Server 2017 Q4511885 KB4511885 October 23, 2020
• 4511884 FIX: Error occurs when a non-dbo user alters procedure in SQL Server 2017 database that has Merge Publication enabled Q4511884 KB4511884 October 23, 2020
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
• 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 October 23, 2020
• 4511715 FIX: Filled transaction log causes outages when you run Query Store in SQL Server 2016 and 2017 Q4511715 KB4511715 October 23, 2020
• 4511593 FIX: DBCC SHOW_STATISTICS permission check fails with an AV error in SQL Server 2016 and 2017 Q4511593 KB4511593 October 23, 2020
• 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 October 23, 2020
• 4509084 FIX: Unexpected index will be deleted when you delete attribute including index in SQL Server 2017 Q4509084 KB4509084 October 23, 2020
• 4508621 FIX: Data processing is much slower in SSAS 2016 SP2 and 2017 than in SSAS 2016 SP1 Q4508621 KB4508621 October 23, 2020
• 4508472 FIX: Intermittent "row not found" error at Azure SQL DB Subscriber caused by duplication of BEGIN TRAN statements Q4508472 KB4508472 October 23, 2020
• 4508065 FIX: Login to SQL Server 2017 on Linux takes more time with SQL authentication than SQL Server 2017 on Windows Q4508065 KB4508065 October 23, 2020
• 4505820 FIX: SQLCLR function takes a longer time to run the query in CU 14 than RTM of SQL Server 2017 Q4505820 KB4505820 October 23, 2020
• 4505726 FIX: Dynamic Data Masking does not function as expected in SQL Server 2017 Q4505726 KB4505726 October 23, 2020
• 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 October 23, 2020
• 4503386 FIX: Exception occurs when you design a parameterized DAX query in Query Designer of Report Builder in SSRS Q4503386 KB4503386 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4502706 FIX: SQL Server generates core dump with "Failed to monitor external signals" in SQL Server 2017 Q4502706 KB4502706 October 23, 2020
• 4502659 FIX: PolyBase queries that target Parquet or ORC files in HDP 3.0 or later will fail with pushdown computation enabled Q4502659 KB4502659 October 23, 2020
• 4502658 FIX: "No valid credentials provided" occurs after you restart PolyBase in SQL Server 2016 and 2017 Q4502658 KB4502658 October 23, 2020
• 4502442 FIX: sys.fn_hadr_backup_is_preferred_replica causes error 41005 in SQL Server 2017 Q4502442 KB4502442 October 23, 2020
• 4502427 FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016 and 2017 Q4502427 KB4502427 October 23, 2020
• 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 October 23, 2020
• 4502380 FIX: SQL Server 2017 crashes because of stack overflow when you try to back up database master to disk Q4502380 KB4502380 October 23, 2020
• 4502376 FIX: Access violation occurs in sqlmin!AGHealthCompStateActual::GetData in SQL Server 2017 Q4502376 KB4502376 October 23, 2020
• 4501797 FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016 and 2017 Q4501797 KB4501797 October 23, 2020
• 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 October 23, 2020
• 4500783 FIX: Interleaved execution on MSTVFs by using memory-optimized tables causes floating point exception in SQL Server 2017 Q4500783 KB4500783 October 23, 2020
• 4500770 FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016 and 2017 Q4500770 KB4500770 October 23, 2020
• 4500595 FIX: CDC Source preview fails with "The given key was not present in the dictionary" error in SQL Server 2017 Q4500595 KB4500595 October 23, 2020
• 4500574 FIX: Self-deadlock occurs when transaction auditing is enabled in SQL Server 2016 and 2017 Q4500574 KB4500574 October 23, 2020
• 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 October 23, 2020
• 4500327 FIX: Non-yielding scheduler issue occurs when you run queries in batch mode that spill in SQL Server 2016 and 2017 Q4500327 KB4500327 October 23, 2020
• 4499614 FIX: Access Violation occurs due to corruption of compressed Showplan.xml file in SQL Server 2017 Q4499614 KB4499614 October 23, 2020
• 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 October 23, 2020
• 4498924 FIX: Gray background for read-only attributes disappears after Refresh in Excel Add-in for MDS in SQL Server 2017 Q4498924 KB4498924 October 23, 2020
• 4498720 FIX: Core dump failed to generate on m_numLocks.load() == 0 error in SQL Server 2017 Q4498720 KB4498720 October 23, 2020
• 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 October 23, 2020
• 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 October 23, 2020
• 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 October 23, 2020
• 4495683 FIX: Search Attribute doesn't work when display format is set to "Name {Code}" in SQL Server 2017 Q4495683 KB4495683 October 23, 2020
• 4495663 FIX: Error 41162 occurs when the creation of distributed availability groups fails in SQL Server 2016 and 2017 Q4495663 KB4495663 October 23, 2020
• 4494650 FIX: Access violation occurs when you run a batch-mode query with UNION statement in SQL Server 2017 Q4494650 KB4494650 October 23, 2020
• 4493364 FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016 and 2017 Q4493364 KB4493364 October 23, 2020
• 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 October 23, 2020
• 4492899 FIX: FileTable database level directory is inaccessible after database startup in SQL Server 2016 and 2017 Q4492899 KB4492899 October 23, 2020
• 4492880 FIX: Automatic seeding assertions occur when databases are removed from AG in SQL Server 2016 and 2017 Q4492880 KB4492880 October 23, 2020
• 4492604 FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016 and 2017 Q4492604 KB4492604 October 23, 2020
• 4490799 FIX: DBCC STACKDUMP doesn't generate dump file for SQL Server 2017 on Linux starting from SQL Server 2017 CU9 to CU13 Q4490799 KB4490799 October 23, 2020
• 4490478 FIX: AD authentication fails to connect to SQL Server 2017 Q4490478 KB4490478 October 23, 2020
• 4490379 FIX: TCP Timeout or login time-out error occurs when you connect to SQL Server 2017 by using Integrated Authentication Q4490379 KB4490379 October 23, 2020
• 4490237 FIX: Restoring backup to SQL Server 2016 and 2017 from SQL Server 2008 or 2008 R2 takes a long time Q4490237 KB4490237 October 23, 2020
• 4490145 Improvement: New mssql-conf option network.enablekdcfromkrb5 is added in SQL Server 2017 Q4490145 KB4490145 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4490137 FIX: TCP Timeout or login time-out error occurs when you connect to SQL Server 2017 using Integrated Authentication Q4490137 KB4490137 October 23, 2020
• 4490136 FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016 and 2017 Q4490136 KB4490136 October 23, 2020
• 4490135 FIX: SQL Server 2017 may crash when local process uses global key event handle Q4490135 KB4490135 October 23, 2020
• 4490134 Improvement: Add a new extended event query_post_execution_plan_profile in SQL Server 2017 Q4490134 KB4490134 October 23, 2020
• 4489202 FIX: Error 10314 occurs when you load .NET CLR assembly in SQL Server 2016 and 2017 database Q4489202 KB4489202 October 23, 2020
• 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 October 23, 2020
• 4488971 FIX: MDS database upgrade fails with error in SQL Server 2016 and 2017 Q4488971 KB4488971 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 October 23, 2020
• 4488400 FIX: Access violation occurs and data movement is suspended for databases in Availability Group in SQL Server 2017 Q4488400 KB4488400 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4487751 FIX: An unexpected exception error occurs when you run a TREATAS function DAX query from Power BI desktop in SSAS 2017 Q4487751 KB4487751 October 23, 2020
• 4486940 FIX: Assertion failure occurs when you try to back up database in limited disk space in SQL Server 2016 and 2017 Q4486940 KB4486940 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4483571 FIX: Possible assertion failure when a cross-database transaction involving an Availability Group database is committed from a SQL Server trigger Q4483571 KB4483571 October 23, 2020
• 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 October 23, 2020
• 4480651 Improvement: Merge operation will consider the number of deleted rows in the rowgroup in SQL Server 2016 and 2017 Q4480651 KB4480651 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4480634 Improvement: IsAvailableInMDX feature can disable processing for specific columns in TREATAS function DAX query in SQL Server 2017 Q4480634 KB4480634 October 23, 2020
• 4480631 FIX: DCExec crashes when you collect data in SQL Server 2017 Q4480631 KB4480631 October 23, 2020
• 4470821 FIX: DBCC CHECKDB on master database fails with error 2570 when Common Criteria Compliance is enabled in SQL Server 2017 Q4470821 KB4470821 October 23, 2020
• 4468101 Improvement: Optional replacement for "String or binary data would be truncated" message with extended information in SQL Server 2016 and 2017 Q4468101 KB4468101 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 October 23, 2020
• 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 October 23, 2020
• 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 October 23, 2020
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 October 23, 2020
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
• 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
• 4046801 “Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016 Q4046801 KB4046801 September 29, 2020
• 4010261 SQL Server and Azure SQL Database improvements in handling some data types and uncommon operations Q4010261 KB4010261 September 29, 2020
• 3200464 Error when you attach a CDC-enabled database to an instance of SQL Server 2016 or SQL Server 2017 on Windows Q3200464 KB3200464 September 29, 2020
• 3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later Q3189675 KB3189675 September 29, 2020
• 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
• 4047326 Technical support policy for Microsoft SQL Server Q4047326 KB4047326 September 23, 2020
• 2295405 SQL Server service crashes when you run an Oracle linked server query Q2295405 KB2295405 August 18, 2020
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
• 2618570 "0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2 and later versions Q2618570 KB2618570 April 14, 2020
• 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 April 9, 2020
• 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
• 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020