SQL Server Versions and Buildnumbers
22 Sep 2022 57794 views 0 minutes to read Contributors 
Including End of Support dates. SQLTreeo delivers support for all SQLServer versions down to 2008R2
SQLServer 2019
| SQLServer | Build number | KB number | Release Date | Cumulative Update number/Security ID | Modern Servicing Model | Includes latest security fixes? | Notes regarding Lifecycle stage |
| 2019 | 15.0.2095.3 | KB 5014356 | 14-Jun-2022 | GDR | GDR | Yes | |
| 2019 | 15.0.4236.7 | KB 5014353 | 14-Jun-2022 | CU16 + GDR | Cumulative Update | Yes | |
| 2019 | 15.0.4223.1 | KB 5011644 | 18-Apr-2022 | CU16 | Cumulative Update | Yes | |
| 2019 | 15.0.4198.2 | KB 5008996 | 27-Jan-2022 | CU15 | Cumulative Update | Yes | |
| 2019 | 15.0.4188.2 | KB 5007182 | 22-Nov-2021 | CU14 | Cumulative Update | Yes | |
| 2019 | 15.0.4178.1 | KB 5005679 | 5-Oct-2021 | CU13 | Cumulative Update | Yes | |
| 2019 | 15.0.4153.1 | KB 5004524 | 4-Aug-2021 | CU12 | Cumulative Update | Yes | |
| 2019 | 15.0.4138.2 | KB 5003249 | 10-Jun-2021 | CU11 | Cumulative Update | Yes | |
| 2019 | 15.0.4123.1 | KB 5001090 | 6-Apr-2021 | CU10 | Cumulative Update | Yes | |
| 2019 | 15.0.4102.2 | KB 5000642 | 11-Feb-2021 | CU9 | Cumulative Update | Yes | |
| 2019 | 15.0.2080.9 | KB 4583458 | 12-Jan-2021 | GDR | GDR | Yes | |
| 2019 | 15.0.4083.2 | KB 4583459 | 12-Jan-2021 | CU8 + GDR | Cumulative Update | Yes | |
| 2019 | 15.0.4073.23 | KB 4577194 | 1-Oct-2020 | CU8 | Cumulative Update | N/A | |
| 2019 | 15.0.4063.15 | KB 4570012 | 2-Sep-2020 | CU7 | Cumulative Update | N/A | (Removed) |
| 2019 | 15.0.4053.23 | KB 4563110 | 4-Aug-2020 | CU6 | Cumulative Update | N/A | |
| 2019 | 15.0.4043.16 | KB 4552255 | 22-Jun-2020 | CU5 | Cumulative Update | N/A | |
| 2019 | 15.0.4033.1 | KB 4548597 | 31-Mar-2020 | CU4 | Cumulative Update | N/A | |
| 2019 | 15.0.4023.6 | KB 4538853 | 12-Mar-2020 | CU3 | Cumulative Update | N/A | |
| 2019 | 15.0.4013.40 | KB 4536075 | 13-Feb-2020 | CU2 | Cumulative Update | N/A | |
| 2019 | 15.0.4003.23 | KB 4527376 | 7-Jan-2020 | CU1 | Cumulative Update | N/A | |
| 2019 | 15.0.2000.5 | 4-Nov-2019 | RTM | RTM | N/A | SQL 2019 RTM Release | |
| 2019 | 15.0.2070.41 | KB 4517790 | 4-Nov-2019 | GDR | GDR | N/A | Servicing Update (Non-Security GDR) |
SQLServer 2019 Detailed Fix List
| KB Article | Description | Feature | Component | Platform | Version | UpdateType | Update | Release Date | Fix Build |
| 5014356 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | SQL Server Engine | Query Execution | Windows | 2019 | RTM | RTM+GDR | 14-Jun-2022 | 15.0.2095.3 |
| 5014353 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU16+GDR | 14-Jun-2022 | 15.0.4236.7 |
| 5011644 | Removes log4j2 used by SQL Server 2019 Integration Services (SSIS) to avoid any potential security issues. | Integration Services | DTS | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | In SQL Server 2019 Master Data Services, the child nodes don’t open in the derived hierarchy when a child entity is joined with a recursive hierarchy. | Master Data Services | Master Data Services | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 4530955 | FIX: Error 18456 occurs when you run DMV queries on the SQL Server 2017 or 2019 instance after rebuilding system databases | Servicing Experience | SQL Server | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The bulk insert is blocked when the lock of the target table is held by another session, and the session of the bulk insert will remain in SQL Server until its lock is released even if the client application disconnects or exits. This issue causes the session to leak and other requests to be blocked if the leaked sessions are accumulated too many. | SQL Server Connectivity | SQL Connectivity | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Running DBCC CHECKDB will report "corruption" errors when you use SQL Server graph databases that have edge constraints. | SQL Server Engine | SQL Engine | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | A “Non-yielding Scheduler” issue and dump occur during a backup operation because of concurrent Page Free Space (PFS) updates. | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Restoring from a compressed backup that contains filestream objects randomly fails if the process is run through the Virtual Device Interface (VDI) client. Here are the error messages: Msg 3241, Level 16, State 18, Line |
SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Restoring transaction logs from a compressed backup of a TDE-enabled database may cause a "misaligned I/O" message to be logged in the SQL Server error log: |
SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An offline, piecemeal restore sequence of restoring individual file groups fails when you use the WITH NO_LOG statement. Here are the error messages: Msg 3241, Level 16, State 18, Line |
SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | A database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read. | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5014136 | Improvement: Ship the EO-compliant ML service CAB packages for SQL Server 2019 | SQL Server Engine | Extensibility | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5014137 | Improvement: Ship the EO-compliant Microsoft Extensibility SDK for Java for SQL Server 2019 | SQL Server Engine | Extensibility | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Improves the dynamic management view (DMV) to help debug the out-of-memory (OOM) issues. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Memory-Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator, which causes out-of-memory (OOM) exceptions like error 701 or FAIL_PAGE_ALLOCATION. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | SQL Server 2019 using XTP UserDB for staging tables has a steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors over time and requires proactive restart/failover to retain stability. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An assertion failure occurs in tempdb during the rollback of transactions, and triggers a server shutdown. The following dump file is generated: |
SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | A memory dump and assertion failure “Dependencies.CommitDepCountOut >= 1” may occur after a transaction rolls back if in-memory tempdb is enabled. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Resolves stalled I/O completion port (IOCP) issues when a heavily used service broker is configured on an availability group database. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The function sys.fn_hadr_backup_is_preferred_replica returns different results on primary or secondary replicas of read-scale availability groups (Cluster_Type=None) when running on standalone machines or cluster nodes | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON after installing a SQL Server Cumulative Update. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated: |
SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An "Out of memory" error occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Calling CMEDScan::EvaluateCmpResult to evaluate filter predicates for the current metadata scan misses the "NE" predicate, which causes an "INVALID_SWITCH_VALUE" exception. | SQL Server Engine | Metadata | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An access violation occurs if a query on sys.database_scoped_configurations is waiting for a shared lock on the database while another thread holds the exclusive lock to drop the same database. | SQL Server Engine | Metadata | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Dropping temp tables in some rare cases causes an unresolved deadlock and dump. | SQL Server Engine | Programmability | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The logon trigger may fail unexpectedly for the pooled connections even when the criteria are not met during the connection reset, and causes the following error: Error:17892, Severity: 20, State: 1. Logon failed for login ' |
SQL Server Engine | Programmability | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Executing a query where the plan contains an adaptive join may fail together with the following error: Msg 8624, Level 16, State 21, Procedure ProcedureName, Line LineNumber [Batch Start Line 0] Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled. | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5014047 | Improvement: Make the change-tracking table lock escalation policy be the same as the base table’s | SQL Server Engine | Replication | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Deleting rows, added before setting up Last Writer Wins (LWW), causes incorrect conflict during deleting a store procedure. | SQL Server Engine | Replication | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Server Engine | SQL OS | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | Adds two new Extended Events, iam_page_range_cache_invalidation and iam_page_range_cache_population, to respectively capture Index Allocation Map (IAM) page range cache invalidation and population. | SQL Server Engine | Storage Management | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | An assertion failure, lck_sufficient (lckMode, LCK_M_IX) || lck_sufficient (lckMode, LCK_M_BU), occurs when you use Accelerated Database Recovery (ADR). | SQL Server Engine | Transaction Services | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5012964 | Improvement: Port an XEvent for manual user plan forcing and unforcing | SQL Server Engine | Query Store | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | A view, created in a table that has an XML index, cannot return the correct result because of missing '%' in LIKE predicate on columns hidden for xml_index_nodes table. | SQL Server Engine | XML | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5011644 | The sqlcmd utility crashes when the batch_terminator parameter "-c" is set to ";" in SQL Server 2019. | SQL Server Client Tools | Command Line Tools | Windows | 2019 | CU | CU16 | 18-Apr-2022 | 15.0.4223.1 |
| 5008996 | Fixes an issue where AVERAGEX(CURRENTGROUP()) function returns the incorrect result that is close to 0 unless you add 0.0 to the measure in the DAX query | Analysis Services | Analysis Services | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL: The given path's format is not supported. Exception Type "System.NotSupportedException" Note To work around the issue, you can change the data default directory to a local directory and rerun the SQL patch. | SQL Setup | Patching | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5010555 | Improvement: Add the usage of signed certificates with multiple DNS names | SQL Server Engine | Surface Area | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue about inconsistent data if you add a date that is between last day of 1899 and first day of March 1900 in the MDS add-in for Excel in SQL Server 2019 | Master Data Services | Master Data Services | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the tooltip of column name doesn't display in SQL Server 2019 Master Data Services (MDS) | Master Data Services | Client | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5010234 | FIX: Buffer overruns when data buffer spans multiple SNI packets | SQL Server Connectivity | Protocols | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the dm_db_page_info function may record spurious corrupted pages entries in the suspect_pages table when calling the function against the transaction log file | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5010653 | FIX: Database corruption after creating an external library in SQL Server 2019 | SQL Server Engine | Extensibility | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes the following insufficient memory error that occurs during In-Memory Online Transactional Processing (OLTP) if application native procedures update tables that have Large Object (LOB) columns and do not specify the LOB column in the UPDATE list: <DateTime> Disallowing page allocations for database 'Retail' due to insufficient memory in the resource pool 'IMOLTP'. <DateTime> XTP failed page allocation due to memory pressure: FAIL_PAGE_ALLOCATION 8 | SQL Server Engine | In-Memory OLTP | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5010246 | Improvement: Add 1 (true) and 0 (false) as valid values to mssql-conf Boolean settings | SQL Server Engine | Linux | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008647 | Improvement: Add mssql-conf and adutil utilities to SQL Server 2019 | SQL Server Engine | Linux | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008648 | Improvement: Add a setting for the machine key location on Linux | SQL Server Engine | Linux | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes a committed memory accounting issue, which under some circumstances, FAIL_PAGE_ALLOCATION error could occur a few days after starting SQL Server services on Linux | SQL Server Engine | Linux | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2019: Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_515697bb-6009-4018-b373-50c871ed736c_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2Features returned by SQL Server: 0x10000 Opening the device. VDS::OpenDevice fails: x80770004 Msg 18210, Level 16, State 1, Server <ServerName>, Line <LineNumber> BackupVirtualDeviceSet::AllocateBuffer: failure on backup device '515697bb-6009-4018-b373-50c871ed736c'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Msg 3013, Level 16, State 1, Server <ServerName>, Line <LineNumber> BACKUP DATABASE is terminating abnormally. | SQL Server Engine | Linux | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Adds the Reverting progress to SQL Server error logs in SQL Server 2019 just like the Recovery progress | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an error that occurs after a failover of a Distributed Availability Group that attempts to connect to the secondary AG listener with application intent set to READ ONLY | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where assertion failure on secondary replica when you use Always On availability groups in high-latency networks in SQL Server 2019. You may see this assert failure in the error log: Assertion: File: <"e:\\b\\s3\\sources\\sql\\ntdbms\\storeng\\dfs\\trans\\lsnlocmap.cpp">, line=358 Failed Assertion = 'pos - pndx < map->EntryCount' | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where a filtered index becomes corrupt after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHECKTABLE WITH EXTENDED_LOGICAL_CHECKS | SQL Server Engine | Metadata | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key | SQL Server Engine | Metadata | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | SQL Server Engine | Metadata | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where java.nio.BufferOverflowException error occurs when using PolyBase external tables to query data from Hadoop. Note This error occurs when querying from a file that has columns of type varchar or nvarchar with a width greater than 256 characters. | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5009753 | FIX: Physical reads are counted twice for read-ahead | SQL Server Engine | Query Execution | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an access violation that occurs in CXPort::Close after you use SQL Server 2019 Cumulative Update 14 (CU14) | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator: Msg 104, Level 16, State 1, Line <LineNumber> ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. | SQL Server Engine | Query Optimizer | Linux;Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the specific statement for compilation in stored procedures seems "stuck" and shows sqlsource_transform until manual intervention | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an assertion in CQPOnDemandTask::ExecuteQPJob if auto async update statistics is enabled. You may see this assert failure in the error log: Assertion: File: <sosmemobj.cpp>, line=2774 Failed Assertion = 'pvb->FLargeAlloc () == FALSE' | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where different conversion results are displayed in publisher and subscriber database tables when using the ASCII function to convert a column. For more information, see ASCII function returns different results in Publisher and Subscriber database tables. | SQL Server Engine | Replication | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes a system-wide low memory issue that occurs when SQL Server commits memory above the maximum server memory under the memory model with the Lock Pages In Memory. Note You should install startup trace flag 8121 to enable this fix. | SQL Server Engine | SQL OS | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB | SQL Server Engine | SQL OS | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes the access violation sqldk!StringVPrintfWorkerW that occurs during the compilation of the query for Dynamic Management Views (DMVs) sys.dm_os_ring_buffers | SQL Server Engine | SQL OS | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Adds improvement in capturing memory dumps on unexpected crashes in SQL Server 2019 on Linux | SQL Server Engine | SQL OS | Linux | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an access violation that occurs when you use FileTable in SQL Server 2019 | SQL Server Engine | FileStream and FileTable | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where Distributed Replay Client may fail with an unhandled exception. This fix is for the Distributed Replay Client that shipped with SQL Server 2019. The following is the error you may observe in the output/log file: DateTime OPERATIONAL [Common] Unhandled exception is encountered. [Exception Code = 3221225477] DateTime OPERATIONAL [Common] Invoking dump. DateTime OPERATIONAL [Common] Service terminating. | SQL Server Client Tools | Database Performance Tools | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes a parallel query executing in batch mode that may cause an access violation and memory dump after installing CU 14. | SQL Engine | Query Execution | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5008996 | Fixes an issue where the Shrink Database task in maintenance plans doesn't work in SQL Server 2019 | SQL Server Client Tools | SSMS | Windows | 2019 | CU | CU15 | 27-Jan-2022 | 15.0.4198.2 |
| 5007182 | Fixes the issue in SSAS 2017, where msmdsrv.log doesn't work when you customize the values of the configuration settings MaxFileSizeMB and MaxNumberOfLogFiles | Analysis Services | Analysis Services | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where the DirectQuery query has no table join clause when you have a DirectQuery model with many-to-many relationship defined and run a DAX query. | Analysis Services | Analysis Services | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the issue in SSIS 2017 when Dimension Processing returns the following error message: clsid {ID}" could not be created and error code 0x80070005 "Access is denied.". Make sure that the component is registered correctly. OnError: "Dimension Processing failed validation and returned error code 0x80040005" | Integration Services | Integration Services | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the issue in MDS 2017, where the derived hierarchy permissions are lost in the copied version | Master Data Services | Master Data Services | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on insert or update of wide replicated table. | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where the CollectPageLatchFields can cause an access violation (AV) under certain timing conditions when the latch_suspend_end XEvent is turned on. The underlying reason is that this method assumes the Buffer is stable under the latch, which isn't true if the Buffer isn't in the Hashtable anymore. This hotfix avoids the AV by checking whether the Buffer is still in the Hashtable before accessing its underlying fields. | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an Access Violation (AV) that can occur when you run dynamic management views (DMVs) queries. | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007794 | FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot | SQL Server Engine | Methods to access stored data | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5004936 | FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value. Msg 3624, Level 20, State 1, Line <LineNumber> A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agree to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.Msg 596, Level 21, State 1, Line <LineNumber> Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line <LineNumber> A severe error occurred on the current command. The results, if any, should be discarded. | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an Access Violation (AV) at RbpEarlyFilter::TinyBitmapFilterSIMD that occurs when you run queries on CLUSTERED COLUMNSTORE INDEX (CCI) tables. Here is the dump file: Stack Dump being sent to <FilePath> SqlDumpExceptionHandler: Process 247 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. BEGIN STACK DUMP: <DateTime spid SpidNum> Exception Address = <AddressNum> Module(sqlmin+<id>) Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION Access Violation occurred reading address <AddressNum> | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where the following warning message occurs during the snapshot creation when you run the DBCC CHECKDB against a database that has a memory optimized filegroup: [WARNING] Unable to create PerfCounter instance for DB xx (xxx): 0x800700b7. | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where you encounter an "ex_terminator - Last chance exception handling" memory dump. The memory dump is associated with a lease timeout while the recovery of an Always On availability groups (AG) database is in progress. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the following error that occurs when you restore a database file (.mdf) that is larger than 15 GB on SQL Server 2019 Big Data Cluster (BDC) with high availability (HA) configuration: Msg 42019, Level 16, State 4, Line <LineNum> RESTORE MANAGED DATABASE operation failed. Internal service error. Msg 3013, Level 16, State 1, Line <LineNum> RESTORE DATABASE is terminating abnormally. | SQL Server Engine | High Availability and Disaster Recovery | Linux | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an access violation exception that may occur when sp_server_diagnostics is executed. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an assert dump "pwchId && cwchId <= MAX_PATH && cwchId > 0" during Always On availability group (AG) Virtual Device Interface (VDI) seeding. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5008114 | FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans | SQL Server Engine | Programmability | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes a self-deadlock issue where thread always waits for HASH_TABLE_DELETE (HTDELETE) when you run parallel query in batch mode. | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes a non-yielding scheduler dump in sqldk!SOS_MemoryWorkSpace::Lookup. | SQL Server Engine | Query Execution | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue causing the assertion fNoReaderWriterConflict. | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007842 | FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue in which the query processor can’t produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where executing a query with BATCH_MODE_ON_ROWSTORE = ON causes the following error and a dump occurs during compilation of the execution plan: Msg 596, Level 21, State 1, Line <LineNumber> Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line <LineNumber> A severe error occurred on the current command. The results, if any, should be discarded. | SQL Server Engine | Query Optimizer | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes the following runtime error that occurs when you build a 32-bit application where Microsoft.SqlServer.Rmo.dll is referenced from C:\Program Files (x86)\Microsoft SQL Server\150\SDK\Assemblies\ but Microsoft.SqlServer.Replication.dll isn’t cached in GAC_32 folder (C:\Windows\Microsoft.NET\assembly\GAC_32) with SQL Server 2019: System.IO.FileNotFoundException HResult=0x80070002 Message= Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. | SQL Server Engine | Replication | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5008296 | FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message | SQL Server Engine | Replication | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007182 | Fixes an issue where SQL Server 2019 stops responding and crashes due to "ex_terminator - Last chance exception handling" when you use SQL Server Service Broker. | SQL Server Engine | Service Broker | Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5008107 | Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 | SQL Server Engine | Spatial | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 4538688 | FIX: Severe spinlock contention occurs in SQL Server 2019 | SQL Server Engine | SQL OS | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007719 | FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019 | SQL Server Engine | Table Index Partition | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5007744 | FIX: Add checkpoint handling for the first row in NonOptimizedGetAndInsertRows | SQL Server Engine | Table Index Partition | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5008184 | FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic | SQL Server Engine | Query Store | Linux;Windows | 2019 | CU | CU14 | 22-Nov-2021 | 15.0.4188.2 |
| 5005679 | Fixes an issue where you cannot complete image because the prepared instance is grayed out if you select [Database Engine Services] along with [Machine Learning Services and Language Extensions]- [Java] in Prepare Image | SQL Setup | User Interface | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where Integration Services packages start failing with the following error when you set ExecuteOutOfProcess property to True: Data Flow Task: Error: The Oracle Source cannot run on the installed edition of Integration Services. It requires Enterprise Edition (64-bit) or higher | Integration Services | Integration Services | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fix an issue where AD Authentication in SQL Server BDC encounters an error "enctype aes256-cts found in keytab but cannot decrypt ticket" if support for 128-bit and 256-bit Kerberos AES encryption is enabled | SQL Server Engine | SQL Big Data Cluster | Linux | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where Memory Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where you cannot edit jobs by using SQL Server Management Studio (SSMS) if SQLAgent permissions are granted at AD group level | SQL Server Engine | Linux | Linux | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostname | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where the assertion results in system suspend of asynchronous secondary replica: DateTime spid36s SQL Server Assertion: File: <"sql\\ntdbms\\storeng\\dfs\\trans\\lsnlocmap.cpp">, line=LineNumber Failed Assertion = 'curr->VlfSeqNo == prev->VlfSeqNo + 1'. This error may be timing-related. restart the server to ensure in-memory data structures are not corrupted | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where Polybase is not generating the partition predicates for pushdown which generates the following error when you do cross-database joins in the backend where one or more of the tables is partitioned: Msg 7320, Level LineNumber, State 110, Line LineNumber Cannot execute the query "Remote Query" against OLE DB provider "MSOLEDBSQL" for linked server "(null)". 105082;Generic ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name '$partition.PF_Polybase' | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5006359 | FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition | SQL Server Engine | Programmability | Linux;Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017 | SQL Server Engine | Replication | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5006665 | Improvement: Last Writer Wins and support for P2P database in Availability Group | SQL Server Engine | Replication | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an issue where 22836 error occurs when you add CDC job again after deleting CDC capture and removing jobs in SQL Server Agent | SQL Server Engine | Replication | Linux;Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5006632 | FIX: An assertion dump occurs many times in SQL Server 2019 | SQL Server Engine | Replication | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 4530907 | Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 | SQL Server Engine | Storage Management | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixes an Access Violation that occurs in SQL Server 2019 when you attempt to add file to database that has backup in progress | SQL Server Engine | Storage Management | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005679 | Fixed an issue where resumable clustered index creation may sometimes fail if a table has lots of LOB columns | SQL Server Engine | Table Index Partition | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5005788 | FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled | SQL Server Engine | FileStream and FileTable | Windows | 2019 | CU | CU13 | 5-Oct-2021 | 15.0.4178.1 |
| 5004524 | Fixes an issue where the DAX query with union generates an exception: An unexpected error occurred (file 'FileName', line LineNumber, function 'FunctionName') | Analysis Services | Analysis Services | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes the issue in SSIS 2019 when Dimension Processing returns clsid {ID}" could not be created and error code 0x80070005 "Access is denied.". Make sure that the component is registered correctly.OnError: "Dimension Processing failed validation and returned error code 0x80040005" | Integration Services | Integration Services | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes the issue in MDS 2019 where Derived hierarchy for domain based attributes is not working properly | Master Data Services | Master Data Services | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where the derived tree cannot load correctly in explore/design page if the hierarchy contains more than two levels recursive | Master Data Services | Client | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes the access violation that occurs at sqllang!srv_nameinfo::SkipOptionalTransportProvider in SQL Server 2019 | SQL Server Connectivity | Protocols | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where running a Full Database Backup on a read-only database containing memory optimized objects fails with the error 3906 "Failed to update database "<DatabaseName>" because the database is read-only." |
SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where frozen I/O leads to latch timeout on database boot page (1:9) and leads to suspended availability group database REDO thread | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004560 | FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019 | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004936 | FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2019 | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5001045 | FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019 | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004734 | FIX: Persisted computed columns not being consistently blocked for Columnstore index | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004750 | FIX: SQL Server often crashes when network.forceencryption property is set to '1' | SQL Server Engine | Linux | Linux | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004649 | FIX: Parallel redo failure on secondary replica in SQL Server 2019 | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes a second exception that occurs when trying to generate a dump on a latch timeout issue and crashes the SQL service entirely | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log: DateSpid Error: 35217, Severity: 16, State: 1. DateSpid The thread pool for Always On Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade Always On Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Adds improvement to replace High Availability Disaster Recovery (HADR) related logs output by Trace Flag (TF) 3605 to the errorlog to a new extended event hadr_trace_message which is written to the alwayson_health session | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where creating an availability group with automatic seeding fails with the error: "Error: 4353 - Conflicting file relocations have been specified for file '<logical_filename>'. Only a single WITH MOVE clause should be specified for any logical file name." due to a database where some files have been created, deleted several times with the same logical filename. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue in SQL Server 2019, if IPv6 is disabled on Linux in the bootloader (GRUB), PolyBase will fail to start | SQL Server Engine | Polybase | Linux | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue in SQL Server 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes the access violation that occurs when you use graph shortest path expressions with LIKE predicates | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where optimizer doesn't push down constant parameters to remote query via linked server | SQL Server Engine | Query Optimizer | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5005321 | FIX: Dropping an index from the view on the primary may cause access violation on readable secondary | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue where NULL values are populated for the $from_id, $to_id columns in a graph edge table when batch mode execution is chosen in SQL Server 2019 | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Ensures that the correct error is returned, when an invalid table name is referenced inside a SHORTEST_PATH query on graph tables in SQL Server | SQL Server Engine | Query Optimizer | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5008996 | Fixes an issue where you see USERSTORE_SCHEMAMGR grow uncontrollably and eventually leading to memory contention issues when you use graph queries in SQL Server 2019 | SQL Server Engine | Query Optimizer | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss | SQL Server Engine | Replication | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixed the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | SQL Server Engine | Spatial | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004573 | FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2019 | SQL Server Engine | SQL OS | Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004524 | Fixes an issue that causes the SQL Server to terminate. ex_terminator - Last chance exception handling | SQL Server Engine | Storage Management | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5004733 | FIX: Debug assert when a lock is acquired by the ParNested Transaction and attempts to get logged in sLog for the parent transaction | SQL Server Engine | Transaction Services | Linux;Windows | 2019 | CU | CU12 | 4-Aug-2021 | 15.0.4153.1 |
| 5003249 | Fixes an issue where a subscribe session can become orphaned and cannot be killed even after subscribed XEvent trace is deleted | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes SSAS 2019 Tabular instance with DirectQuery mode generates unexpected SQL syntax to CAST <col> as VARCHAR(4000) against Teradata CHAR data type | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where DAX query with var calculatetable and filter may return inconsistent result in SSAS 2019 after upgrading from 2017 | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the SSAS 2019 Multidimensional mode no global cache issue when role security involves CustomData() func | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the incorrect results that occur in SSAS 2019 tabular mode when a DAX queries a calculated measure that depends on calc group Calculation item | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the memory consumption issue that occurs when Model processing in SSAS 2019 consumes more memory, when compared to same model processing in SSAS 2017 | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue with performance when tabular queries in SSAS 2019 take more time to execute compared to SSAS 2016 | Analysis Services | Analysis Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where Setup Account Privileges check may not performed when installing CU or Security Update | SQL Setup | Patching | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue in explore page where the Day value changes to 1 if you input 31 some times | Master Data Services | Client | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the error 3628 that occurs frequently when In-Memory OLTP is enabled in SQL Server 2019 and you may receive an error message as shown below: DateTime Error: 3628, Severity: 16, State: 1. DateTime The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019 | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issues that causes query to be stuck in BATCH_MODE_SORT in SQL Server 2019 | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003388 | Fixes an issue in which queries that use the Clustered Columnstore Index (CCI) Key Lookup operator return fewer than the actual number of records when you run CCI reorg commands | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003750 | FIX: Performance issues occur when metadata is scanned to find keys to be sent to the AE enclave in SQL Server 2019 | SQL Server Engine | Security Infrastructure | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003596 | FIX: Log line is extremely high when Always On Availability Group has many databases in SQL Server 2019 | SQL Server Engine | High Availability and Disaster Recovery | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Adds improvement to increase the default size and file retention on AlwaysOn_health. Note The current definition for the AlwaysOn_health XEvent session has a maximum file size of 5 megabytes (MB) and maximum number of files of 4, for a maximum of 20 MB of AlwaysOn_health XEvent data. On a busy system, you can roll over this limitation quickly and miss important information in the event of an issue that affects the system. In order to keep more troubleshooting data available on the system, the default file size is changed from 5 MB to 100 MB and the default number of files is changed from 4 to 10, for a maximum of 1 GB of AlwaysOn_health XEvent data, in this update. If the definition of the AlwaysOn_health session has already been modified from the default values, this improvement will not overwrite the existing settings. | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where an availability group database restart process is blocked when the database is transitioned to a new state because of an availability group failover or lease timeout on the primary replica | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003589 | FIX: Error 19432 occurs when Log Writer thread fails to send a log back and stop log capture on Log Writer threads in SQL Server 2019 | SQL Server Engine | High Availability and Disaster Recovery | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue that causes database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003342 | FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017 | SQL Server Engine | LocalDB | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 4023170 | FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 | SQL Server Engine | Management Services | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003937 | Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 | SQL Server Engine | Metadata | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where executing a PolyBase related query encounters error "Invocation of TransactionStateCreate resulted in -1" and causes PolyBase Data Movement service memory dump | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003525 | Improvement: ADLS Gen2 support for External Tables | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes failures in PolyBase queries involving date/time literals or integer divisions that may occur when the Microsoft Spark ODBC driver is used to connect to a generic ODBC external data source | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where the JVM will eventually crash with an out of memory error after a certain number of queries due to threads not being properly cleaned up in certain scenarios when you use PolyBase Hadoop bridge data sources in SQL Server 2019 on Linux | SQL Server Engine | Polybase | Linux | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue which leads to the impossibility of creating JAVA dumps and thus hampers debuggability and supportability when a PolyBase JAVA HadoopBridge process is started under Linux, an invalid -XX:HeapDumpPath JVM option is passed to the JVM | SQL Server Engine | Polybase | Linux | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003869 | FIX: Support schema reflection stored procedures for the Polybase generic ODBC connector | SQL Server Engine | Polybase | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003870 | FIX: Support using the PolyBase SQL Server connector to create external table with remote database name containing a period | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 4538581 | FIX: Scalar UDF Inlining issues in SQL Server 2019 | SQL Server Engine | Programmability | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the performance issues that occur with concurrent executions of stored procedures on CHANGETABLE and syscommittab by enforcing index seek on change tracking side tables in SQL Server 2019 | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes an issue where sp_hadr_verify_replication_publisher displays wrong distribution database name in error | SQL Server Engine | Replication | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | When published database is part of availability group and listener is on a non-default port, replication monitor doesn’t display publication and subscription information. This CU fixes that issue. | SQL Server Engine | Replication | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all the memory available is taken | SQL Server Engine | Spatial | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes the high SOS_SUSPEND_QUEUE spinlock contention with parallel window aggregate | SQL Server Engine | SQL OS | Linux;Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5003249 | Fixes a potential issue that causes error 5511 when performing a log backup on a database that has filestream data | SQL Server Engine | FileStream and FileTable | Windows | 2019 | CU | CU11 | 10-Jun-2021 | 15.0.4138.2 |
| 5001090 | Fixes an issue where synchronizeSecurity setting of AMO method 'Microsoft.AnalysisServices.Tabular.Server.Synchronize' shown in Server.Synchronize Method is ignored | Analysis Services | Analysis Services | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue with performance when tabular queries in SSAS 2019 take more time to execute compared to SSAS 2016 | Analysis Services | Analysis Services | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes the unexpected date conversion on some special date format | Master Data Services | Client | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue in SQL Server 2019 where kubeadm-prod install hangs on compute/master pods when netbios name and ouDistinguishedName have mismatch | SQL Server Engine | SQL Big Data Cluster | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8 | SQL Server Engine | SQL Big Data Cluster | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | When a VSS backup tries to back up SQL Server databases that are hosted on the forwarder replica of a Distributed Availability Group, the backup operation fails. This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally. In the error log, you may see the following error: DateTime Backup Error: 3041, Severity: 16, State: 1. DateTime Backup BACKUP failed to complete the command BACKUP DATABASE DatabaseName. Check the backup application log for detailed messages. | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Query execution may experience an intra-query deadlock if the query plan is using a single threaded batch mode sort operator before a Repartition Streams Parallelism operator | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001159 | FIX: Assertion failure occurs when Online Clustered Columnstore Index Rebuild reuses truncated hobt instead of new hobt in SQL Server 2019 | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001526 | FIX: Access violation occurs when Dynamic Data Masking and nested UDFs are used in SQL Server 2019 | SQL Server Engine | Security Infrastructure | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001517 | FIX: Metadata deadlock causes availability issues when changing auditing properties in SQL Server 2019 | SQL Server Engine | Security Infrastructure | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5000650 | FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019 | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001044 | FIX: Wrong results occur when you run a query on In-memory optimized tables in SQL Server | SQL Server Engine | In-Memory OLTP | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Improves AD keytab rotation by properly handling the keytab entries with future KVNOs when SSSD is disabled | SQL Server Engine | Linux | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Disables FQDNs in AD usernames when creating/modifying SQL Logins/users for SQL Server 2019 on Linux | SQL Server Engine | Linux | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where a failed network connection results in a socket leak | SQL Server Engine | Linux | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes the following dump exception after login failures in SQL Server 2019: ex_raise2: Unhandled exception raised, major=36, minor=2, state=52, severity=25 | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where out of memory occurs when you take a log backup frequently and Stolen Server Memory grows at an synchronous secondary in Availability Groups | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an Access Violation (AV) that occurs when error is being collected for Availability Group (AG) DB Failover while there is an AG failover undergoing | SQL Server Engine | High Availability and Disaster Recovery | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 4486936 | FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server | SQL Server Engine | Management Services | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Allows pushdown of filter predicate for PolyBase query that utilizes FORMAT or TRIM functions in the SELECT clause if the query is otherwise qualified for pushdown | SQL Server Engine | Polybase | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an Access Violation error that can occur when you import large amount of data to Windows Azure Blob storage. This can occur if PolyBase Data Movement Service encounters out-of-memory condition during large data insert transaction. | SQL Server Engine | Polybase | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where you notice that spurious CAST operations in PolyBase external pushdown queries can dramatically affect the performance with some backends | SQL Server Engine | Polybase | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 4589350 | FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server | SQL Server Engine | Query Execution | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5000649 | FIX: Wrong results due to undetected concatenation parameters from scalar expression | SQL Server Engine | Query Execution | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5000649 | FIX: Wrong results due to undetected concatenation parameters from scalar expression | SQL Server Engine | Query Execution | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where query compilation that involves auto create statistics fails with the following error log: Datetime spidId Error: 3628, Severity: 16, State: 1. Datetime spidId The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes to keep 'PERSIST_SAMPLE_PERCENT' value for statistics on an indexed column after index rebuild | SQL Server Engine | Query Optimizer | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5000715 | FIX: Failures with log reader agent occurs when you create and drop publication on CDC enabled database in SQL Server 2016 and 2019 | SQL Server Engine | Replication | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue with the Foreign Key added to a table that is referencing a table's column which is part of a unique index with included columns. When the table's ALTER command is replicated, Distribution Agent fails with the following error message. Number of referencing columns in foreign key differs from number of referenced columns, table 'TableName'. (Source: MSSQLServer, Error number: 8139) | SQL Server Engine | Replication | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where the query based on full-text indexes is not returning the expected values | SQL Server Engine | Search | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001260 | Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server | SQL Server Engine | Spatial | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes a high HADR_SYNC_COMMIT waits which may show on SQL Server with heavy workload after you apply CU7 | SQL Server Engine | SQL OS | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | SQL Server Service is not starting and failing with core dump after applying SQL Server 2019 CU8 | SQL Server Engine | SQL OS | Linux | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue that enables Block Caching for MMLarge memory model in SQL Server 2019 | SQL Server Engine | SQL OS | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Improvement: Records stage of failure and error during stack copy for better diagnostics | SQL Server Engine | SQL OS | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001266 | FIX: Access Violation occurs when hybrid buffer pool is enabled in SQL Server 2019 | SQL Server Engine | SQL OS | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where performance counter Data File(s) Size (KB) doesn’t report the correct total size of database files if one file is created with initial size > 4 TB or grown by more than 4TB | SQL Server Engine | Storage Management | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Fixes an issue where DBCC PAGE with option 3 generates access violation dumps after dropping a unique identifier column from the table in SQL Server 2019. Msg 596, Level 21, State 1, Line LineNumber Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line LineNumber A severe error occurred on the current command. The results, if any, should be discarded. | SQL Server Engine | Storage Management | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 5001090 | Adds a new option to free the LogPool cache only: DBCC FREESYSTEMCACHE('LogPool') | SQL Server Engine | Transaction Services | Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 4548523 | FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error | SQL Server Engine | DB Management | Linux;Windows | 2019 | CU | CU10 | 6-Apr-2021 | 15.0.4123.1 |
| 4589170 | FIX: Indefinite hang occurs during cube processing after applying SSAS 2016 SP2 CU7 | Analysis Services | Analysis Services | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4589171 | FIX: Unexpected error occurs when a query is run on an instance of SSAS | Analysis Services | Analysis Services | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes deadlocks that occur in [catalog].[set_execution_property_override_value] | Integration Services | Engine | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | FIX: SSIS ScaleOut Execution intermittently reports "Unexpected Termination" in the execution status but all tasks gets completed successfully | Integration Services | ScaleOut | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Improves SSISDB performance by adding indexes to event_message_context and execution_property_override_values tables in SQL Server 2019 | Integration Services | Server | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4569837 | FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager | Integration Services | Tasks_Components | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | FIX: When the master SSIS package calls multiple child packages and their connection managers are parameterized, the SSIS package execution fails with UNEXPECTED TERMINATION or INVALID CONNECTION STRING ATTRIBUTE error while updating connection strings. | Integration Services | Tasks_Components | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4547890 | FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server | Integration Services | Tools | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes an access violation exception that occurs while querying sys.dm_db_stats_properties for a table with a spatial index in SQL Server 2019 | Master Data Services | Master Data Services | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes the issue of sending done token before sending the session kill state when session got killed. This fixes the issue of incorrect session state that occurs when a session is killed on SQL Server external data source instance | SQL Server Connectivity | SQL Connectivity | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4588977 | FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails | SQL Server Connectivity | Protocols | Linux | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4594016 | FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019 | SQL Server Engine | Methods to access stored data | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes an issue where deployment is stuck in 'WaitingForControlPlaneFilesDownload' state with ObjectDisposedException in controller | SQL Server Engine | SQL Big Data Cluster | Linux | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes an issue where a database restore fails with an error 3257 (insufficient free space error) when the database is larger than 2TB. The issue happens when the TotalAllocationUnits on the target volume is more than 4,294,967,295 units, for example when the target volume is larger than 16TB and uses an allocation unit size = 512 bytes and a single sector per cluster. | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4577775 | When running a RESTORE HEADERONLY of a SQL Server 2016 backup you may notice error 3285 even if the correct block size has been specified. If the error persists after applying this fix, specify the proper block size or contact Microsoft Support for assistance | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4577775 | FIX: When you try to restore from a compressed or encrypted backup over an existing TDE enabled database, you may notice that the restore operation may take longer time than expecte | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes an error where you may receive the following error when you restore a TDE enabled database from a backup with compression option and "with file =" option is greater than 1. Msg 3241, Level 16, State 40, Line LineNumberThe media family on device 'FilePath\FileName' is incorrectly formed. SQL Server cannot process this media family. | SQL Server Engine | Backup Restore | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4588980 | FIX: Higher than expected number of single row Columnstore rowgroups may be generated for Columnstore bulk insert when both large page allocator and scalable Columnstore bulk insert features are turned on | SQL Server Engine | Column Stores | Linux;Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000895 | Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index | SQL Server Engine | Column Stores | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000656 | FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019 | SQL Server Engine | Security Infrastructure | Linux;Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000655 | FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019 | SQL Server Engine | Security Infrastructure | Linux;Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4577775 | FIX: VERIFY_CLONEDB prints message 'Clone database verification has failed' for the database if the database name starts with a number | SQL Server Engine | DB Management | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Updates the Zulu JRE version to mssql-zulu-jre-11.43.56-1 and mssql-zulu-jre-8-8.50.0.52-1 | SQL Server Engine | Extensibility | Linux | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Updates the Zulu JRE version to mssql-zulu-jre-11.43.56 | SQL Server Engine | Extensibility | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4580397 | FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server | SQL Server Engine | In-Memory OLTP | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes an error that occurs when you execute a query by using sp_send_dbmail inside a SQL Agent Job to send mails with attachments | SQL Server Engine | Linux | Linux | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | Fixes infinite loop in VDI due to improper initialization of errno variable | SQL Server Engine | Linux | Linux | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 5000642 | FIX: Assertion or RaiseInconsistencyError occurs when you use VersionStoreTableAccess::PopulateRowData on SQL 2019 Always On Availability Group Readable replica, but actually there is no corruption | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4568447 | FIX: Automatic seeding failure occurs for a secondary replica in SQL Server 2016 and 2019 | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |
| 4577932 | FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions | SQL Server Engine | High Availability and Disaster Recovery | Windows | 2019 | CU | CU9 | 11-Feb-2021 | 15.0.4105.2 |