kbupdate.info ›
Daily Updated!
SQL Server 2019 articles, fixes and updates - Year 2020
Daily Updated!
chronological list: 2024 | 2023 | 2022 | 2021/11 10 9 8 6 5 4 3 2 1 | 2020 | 2019
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2019 that have been released in Year 2020. The list is daily updated.
- 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
- 4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 October 24, 2020
- 4538384 CDC capture job fails when processing changes for a table with system CLR datatype (geometry, geography, or hierarchyid) Q4538384 KB4538384 October 24, 2020
- 4533057 "Query optimizer generated too many subcubes" error and MDX query fails in SSAS multidimensional instance Q4533057 KB4533057 October 24, 2020
- 4581882 FIX: Restoring database fails due to backup command time-out in SQL Server 2019 Q4581882 KB4581882 October 23, 2020
- 4578395 FIX: Error occurs when using DBCC operations while TDE key change occurs in SQL Server 2019 Q4578395 KB4578395 October 23, 2020
- 4578267 FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019 Q4578267 KB4578267 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
- 4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 October 23, 2020
- 4577836 FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset Q4577836 KB4577836 October 23, 2020
- 4577591 FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 Q4577591 KB4577591 October 23, 2020
- 4577590 FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 Q4577590 KB4577590 October 23, 2020
- 4577562 FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 Q4577562 KB4577562 October 23, 2020
- 4577561 FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 Q4577561 KB4577561 October 23, 2020
- 4576778 FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower Q4576778 KB4576778 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
- 4575275 FIX: Access violation occurs when MSTVF references an In-Memory OLTP large-value data type with interleaved execution enabled in SQL Server 2019 Q4575275 KB4575275 October 23, 2020
- 4574801 FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 Q4574801 KB4574801 October 23, 2020
- 4570679 FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux Q4570679 KB4570679 October 23, 2020
- 4570571 FIX: Query slowness may occur when CPU-intensive SQL Server system tasks run in SQL Server 2019 Q4570571 KB4570571 October 23, 2020
- 4570433 FIX: "Culture is not supported" error or wrong results occur when you run PolyBase query in SQL Server 2019 Q4570433 KB4570433 October 23, 2020
- 4570355 FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019 Q4570355 KB4570355 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
- 4564876 FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019 Q4564876 KB4564876 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
- 4563195 FIX: sp_execute_external_script may fail to run R scripts that use the RxLocalParallel compute context or the doParallel R package in SQL Server 2019 Q4563195 KB4563195 October 23, 2020
- 4563044 FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows Q4563044 KB4563044 October 23, 2020
- 4562618 FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019 Q4562618 KB4562618 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
- 4561915 Improvement: MAXTRANSFERSIZE no longer required to enable backup compression on TDE encrypted databases Q4561915 KB4561915 October 23, 2020
- 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 October 23, 2020
- 4560051 FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO Q4560051 KB4560051 October 23, 2020
- 4556244 FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux Q4556244 KB4556244 October 23, 2020
- 4556233 FIX: Setup is unable to extract product update when it is executed as LOCAL SYSTEM with UPDATE SOURCE option specified in SQL Server 2019 Q4556233 KB4556233 October 23, 2020
- 4555232 FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019 Q4555232 KB4555232 October 23, 2020
- 4552205 FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019 Q4552205 KB4552205 October 23, 2020
- 4552159 FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019 Q4552159 KB4552159 October 23, 2020
- 4551838 FIX: Memory leak by Controller container in SQL Server 2019 BDC Q4551838 KB4551838 October 23, 2020
- 4551781 Update terms of use for SQL Server 2019 Q4551781 KB4551781 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
- 4550657 FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019 Q4550657 KB4550657 October 23, 2020
- 4548751 App-V Server publishing might fail when you apply user configuration files with SQL Server 2016 or later Q4548751 KB4548751 October 23, 2020
- 4548133 FIX: Data length/size of Unicode nvarchar data type column is not correct for OutputDataSet in sp_execute_external_script query in SQL Server 2019 on Linux Q4548133 KB4548133 October 23, 2020
- 4548131 FIX: Fail to access openmpi path when running rx jobs in parallel mode with Revo package in Linux SQL Server 2019 Q4548131 KB4548131 October 23, 2020
- 4548103 FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019 Q4548103 KB4548103 October 23, 2020
- 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 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
- 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 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
- 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
- 4540372 FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 Q4540372 KB4540372 October 23, 2020
- 4540371 FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 Q4540371 KB4540371 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
- 4540121 FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory Q4540121 KB4540121 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
- 4539203 FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019 Q4539203 KB4539203 October 23, 2020
- 4539201 FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 Q4539201 KB4539201 October 23, 2020
- 4539200 FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 Q4539200 KB4539200 October 23, 2020
- 4539199 FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 Q4539199 KB4539199 October 23, 2020
- 4539198 FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 Q4539198 KB4539198 October 23, 2020
- 4539197 FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 Q4539197 KB4539197 October 23, 2020
- 4539172 FIX: Launchpad services fails to start during failover in SQL Server 2019 Q4539172 KB4539172 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
- 4539000 FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 Q4539000 KB4539000 October 23, 2020
- 4538978 Improvement: Add BDC storage pool cache in SQL Server 2019 Q4538978 KB4538978 October 23, 2020
- 4538968 FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 Q4538968 KB4538968 October 23, 2020
- 4538858 FIX: Dumps occur because of OOM condition in SQL Server 2019 Q4538858 KB4538858 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
- 4538759 Improvement: Module and offset information is sent as output for dumps in SQL Server 2019 Q4538759 KB4538759 October 23, 2020
- 4538689 Improvement: Add BDC data/storage pool nodes DMVs in SQL Server 2019 Q4538689 KB4538689 October 23, 2020
- 4538686 Improvement: Add new Protection Key feature work for SQL Server 2019 on Linux Q4538686 KB4538686 October 23, 2020
- 4538595 Improvement: New features included in library management for external languages in SQL Server 2019 Q4538595 KB4538595 October 23, 2020
- 4538575 FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 Q4538575 KB4538575 October 23, 2020
- 4538573 FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger Q4538573 KB4538573 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
- 4538495 FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019 Q4538495 KB4538495 October 23, 2020
- 4538481 FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019 Q4538481 KB4538481 October 23, 2020
- 4538382 Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux Q4538382 KB4538382 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
- 4538344 FIX: Passwords are masked in audit logs in SQL Server 2019 Q4538344 KB4538344 October 23, 2020
- 4538342 FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 Q4538342 KB4538342 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
- 4538164 FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 Q4538164 KB4538164 October 23, 2020
- 4538163 FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019 Q4538163 KB4538163 October 23, 2020
- 4538162 FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition Q4538162 KB4538162 October 23, 2020
- 4538161 FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 Q4538161 KB4538161 October 23, 2020
- 4538159 FIX: Calculation with summarizecolumn returns unexpected results after upgrading to SSAS 2019 with compatibility level 1500 Q4538159 KB4538159 October 23, 2020
- 4538118 Improvement: Enable hybrid buffer pool read caching in SQL Server 2019 Q4538118 KB4538118 October 23, 2020
- 4538112 Improvement: Use QUOTENAME with EXECUTE AT to query on table that has column name with quotes in SQL Server 2019 Q4538112 KB4538112 October 23, 2020
- 4538036 FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC Q4538036 KB4538036 October 23, 2020
- 4537869 FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 Q4537869 KB4537869 October 23, 2020
- 4537751 FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019 Q4537751 KB4537751 October 23, 2020
- 4537710 FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 Q4537710 KB4537710 October 23, 2020
- 4537452 FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 Q4537452 KB4537452 October 23, 2020
- 4537401 FIX: Custom date format with time doesn't work properly in SQL Server 2019 Master Data Services Q4537401 KB4537401 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
- 4537347 FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 Q4537347 KB4537347 October 23, 2020
- 4537072 FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions Q4537072 KB4537072 October 23, 2020
- 4536841 FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019 Q4536841 KB4536841 October 23, 2020
- 4536684 FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019 Q4536684 KB4536684 October 23, 2020
- 4536077 FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 Q4536077 KB4536077 October 23, 2020
- 4534981 FIX: Additional cluster resources are removed by the "azdata bdc delete" command Q4534981 KB4534981 October 23, 2020
- 4534249 FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server Q4534249 KB4534249 October 23, 2020
- 4534148 FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 Q4534148 KB4534148 October 23, 2020
- 4533497 FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019 Q4533497 KB4533497 October 23, 2020
- 4533251 FIX: Upgrading FCI passive node from SQL Server 2019 RC1 to RTM fails when you try to access the MSSQL\JOBS which is on the shared drive Q4533251 KB4533251 October 23, 2020
- 4531384 FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations Q4531384 KB4531384 October 23, 2020
- 4531349 FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 Q4531349 KB4531349 October 23, 2020
- 4531238 FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database Q4531238 KB4531238 October 23, 2020
- 4531232 FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019 Q4531232 KB4531232 October 23, 2020
- 4531226 FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019 Q4531226 KB4531226 October 23, 2020
- 4531225 FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 Q4531225 KB4531225 October 23, 2020
- 4531224 FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 Q4531224 KB4531224 October 23, 2020
- 4531125 Improvement: Update the hktempdb.dll version in SQL Server 2019 Q4531125 KB4531125 October 23, 2020
- 4531049 FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 Q4531049 KB4531049 October 23, 2020
- 4531029 FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019 Q4531029 KB4531029 October 23, 2020
- 4531026 FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019 Q4531026 KB4531026 October 23, 2020
- 4531025 Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019 Q4531025 KB4531025 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
- 4530827 FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 Q4530827 KB4530827 October 23, 2020
- 4530814 Improvement: Add support to create index on encrypted unique identifier using Always Encrypted with secure enclaves feature in SQL Server 2019 Q4530814 KB4530814 October 23, 2020
- 4530769 FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters Q4530769 KB4530769 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
- 4530499 FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 Q4530499 KB4530499 October 23, 2020
- 4530496 FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 Q4530496 KB4530496 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
- 4530468 FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 Q4530468 KB4530468 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
- 4530427 FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 Q4530427 KB4530427 October 23, 2020
- 4530303 FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 Q4530303 KB4530303 October 23, 2020
- 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 Q4530302 KB4530302 October 23, 2020
- 4530286 Improvement: Update SDK to improve security of Always Encrypted by using secure enclaves in SQL Server 2019 Q4530286 KB4530286 October 23, 2020
- 4530283 Improvement: Execute Database upgrade scripts when Database state changes in SQL Server 2019 Q4530283 KB4530283 October 23, 2020
- 4530281 FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 Q4530281 KB4530281 October 23, 2020
- 4530280 Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019 Q4530280 KB4530280 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
- 4530097 FIX: Package execution may be impacted in SQL Server 2019 Integration Services Q4530097 KB4530097 October 23, 2020
- 4530084 FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU Q4530084 KB4530084 October 23, 2020
- 4530080 Improvement: Update the misspelled words in server_principal_sid and server_principal_name description in SQL Server 2019 Q4530080 KB4530080 October 23, 2020
- 4530079 Improvement: Update error messages of Always Encrypted with secure enclaves in SQL Server 2019 Q4530079 KB4530079 October 23, 2020
- 4530055 FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019 Q4530055 KB4530055 October 23, 2020
- 4530054 FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 Q4530054 KB4530054 October 23, 2020
- 4529944 FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 Q4529944 KB4529944 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
- 4529893 FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019 Q4529893 KB4529893 October 23, 2020
- 4529848 FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 Q4529848 KB4529848 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
- 4528492 FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 Q4528492 KB4528492 October 23, 2020
- 4528491 FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 Q4528491 KB4528491 October 23, 2020
- 4528490 FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 Q4528490 KB4528490 October 23, 2020
- 4528337 FIX: Assertion error when you run internal query in batch mode for populating full-text index on computed LOB in SQL Server 2019 Q4528337 KB4528337 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
- 4528168 FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 Q4528168 KB4528168 October 23, 2020
- 4528139 FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 Q4528139 KB4528139 October 23, 2020
- 4528097 FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 Q4528097 KB4528097 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
- 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
- 4527165 FIX: SQL Server Browser doesn't respond through clustered IP address from a SQL Server 2019 Failover Clustered Instance (FCI) Q4527165 KB4527165 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
- 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
- 4521702 FIX: ObjectPropertyEx Cardinality property for columnstore table doesn't include rows in delta store rowset or account rows in deleted bitmap rowset in SQL Server 2019 Q4521702 KB4521702 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
- 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
- 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
- 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
- 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
- 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 October 23, 2020
- 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 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
- 4538493 Improvement: Restore database and add database to the AG in SQL Server 2019 Q4538493 KB4538493 February 15, 2020
- 4540343 FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019 Q4540343 KB4540343 February 14, 2020
- 4538685 FIX: SQL Server 2019 Express SLT incorrectly states that Express is not allowed for production use Q4538685 KB4538685 February 14, 2020
- 4538661 FIX: New sandbox is created unexpectedly when sandbox cleanup fails and child process is still alive Q4538661 KB4538661 February 14, 2020
- 4538515 FIX: Concurrent PFS update in SQL Server 2019 may cause corruption of ADR Q4538515 KB4538515 February 14, 2020
- 4538160 Improvement: Correct the floating point data type in SQL Server 2019 Q4538160 KB4538160 February 14, 2020
- 4537300 FIX: Change the NuGet that's used for Polaris in SQL Server 2019 Q4537300 KB4537300 February 14, 2020
- 4531702 FIX: Assertion occurs when TF 831 is turned ON/OFF multiple times in SQL Server 2019 Q4531702 KB4531702 February 14, 2020
- 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020