SQL Server 2022 Release Notes

Release notes for SQL Server 2022 CU23

This article describes Cumulative Update package 23 (CU23) for Microsoft SQL Server 2022. This update contains 15 fixes that were issued after the release of SQL Server 2022 Cumulative Update 22. It updates components in the following builds:

• SQL Server - Product version: 16.0.4236.2, file version: 2022.160.4236.2
• Analysis Services - Product version: 16.0.43.252, file version: 2022.160.43.252

Important

The initial release of this cumulative update (KB5074819), released on January 15, 2026, contained an issue that caused Database Mail to stop working. You might also see the following error message:
Could not load file or assembly 'Microsoft.SqlServer.DatabaseMail.XEvents, Version=17.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
This issue affects SQL Server product version 16.0.4235.2 and file version 2022.160.4235.2.
This issue is resolved in the current version of this cumulative update (KB5078297).
If you downloaded the initial release of this update, don't install it. Download and install the current version instead.
If you already installed the initial release, uninstall it or install the current version to restore Database Mail functionality.
Future cumulative updates also contain the fix for this issue. You can install them regardless of which version of this cumulative update is currently installed.
Email messages queued through Database Mail while the initial release was installed aren't automatically resent when you uninstall it or install a cumulative update that contains the fix.

Known issues in this update

Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.

Improvements and fixes included in this update

A downloadable Microsoft Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Download this Excel file now.

Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.
For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following table.

Bug reference Description Fix Area Component Platform 4676249 Fixes an issue in which backup log operations fail and return an error that indicates that BACKUP LOG is not allowed while the recovery model is SIMPLE. - SQL Server Engine - Backup Restore - Windows 4710575 Fixes an AV assertion issue in DbMgrPartner that's related to new log readiness notifications. - SQL Server Engine - High Availability and Disaster Recovery - All 4769216 Fixes an issue in which non-yielding scheduler dump files are generated when SSL connections are closed under high CPU load. - Connectivity - Protocols - All 4783675 Fixes an issue in which upgrading from SQL Server 2019 to SQL Server 2022 might cause the upgrade process to stop responding during the model database upgrade phase. - SQL Server Engine - Programmability - All 4783748 Changes the behavior of the program to return error 19544 instead of returning an assert when you create an availability group that has a name that's longer than 64 characters by using cluster_type = NONE or EXTERNAL. - SQL Server Engine - High Availability and Disaster Recovery - All 4796333 Fixes an issue that causes crashes when an invalid ID type is returned from the Domain Controller in LookupAccountSid. - SQL Server Engine - Linux - Linux 4796376 Fixes an issue that prevents Active Directory logins from working if the keytab file is updated too long after the privileged user password is rotated. - SQL Server Engine - Linux - Linux 4798276 Fixes an issue in which Distributed Availability Group seeding fails if the local Availability Group is offline. - SQL Server Engine - High Availability and Disaster Recovery - Windows 4807292 Fixes a failure to configure multiple concurrent auditing to write to the Security Event log during updates. - SQL Server Engine - Security Infrastructure - All 4811256 Fixes a crash that's caused by a missing partition in a common table expression (CTE). - SQL Server Engine - Programmability - All 4818763 Fixes a bug that causes memory allocation failure during VDI restore operations if memory is limited through cgroupsv2 on Linux. - SQL Server Engine - Linux - Linux 4837925 Fixes an issue in which SSCM fails when it imports certain certificates, including self-signed certificates that are password protected and certificates exported from Azure AKV that are not password protected. - SQL Server Configuration Manager - Certificate Import - Windows 4838959 Restricts privileges for dbcc stackdump so that only the sysadmin can invoke the dump file. - SQL Server Engine - Security Infrastructure - All 4849635 Fixes an issue in which AppDomains in a DOOMED state are not unloaded correctly. - SQL Server Engine - Query Execution - All 4866387 Allows using the sys.fn_xe_file_target_read_file() function to read system_health event session data in Azure SQL Managed Instance. - SQL Server Engine - SQL OS - Windows

How to obtain or download this or the latest cumulative update package

File information

Notes for this update

How to uninstall this update

References

Last updated on 01/29/2026

Original source Report a problem

Known issues in this update

Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.

Improvements and fixes included in this update

A downloadable Microsoft Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Download this Excel file now.

Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.

For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following table.

[Table of fixes with Bug reference, Description, Fix area, Component, Platform]

How to obtain or download this or the latest cumulative update package

File information

Notes for this update

How to uninstall this update

References

Original source Report a problem

Known issues in this update

Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.

Improvements and fixes included in this update

A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Download this Excel file now.

Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.

For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following table.

[Table of Improvements and fixes included in this update with bug references, descriptions, fix areas, components, and platforms]

How to obtain or download this (or the latest) cumulative update package

[Instructions and links for obtaining or downloading the update]

File information

[File hash information and cumulative update package file information]

Notes for this update

[Prerequisites, restart information, registry information, important notices, hybrid environment deployment, language support, components updated, support for this update]

How to uninstall this update

[Instructions for uninstalling this update on Windows and Linux]

References

• Announcing updates to the SQL Server Incremental Servicing Model (ISM)
• SQL Server Service Packs are no longer supported starting from SQL Server 2017
• Determine which version and edition of SQL Server Database Engine is running
• Servicing models for SQL Server
• Naming schema and Fix area descriptions for SQL Server software update packages
• Description of the standard terminology that is used to describe Microsoft software updates

Last updated on 09/11/2025

Original source Report a problem

Summary

This article describes Cumulative Update package 20 (CU20) for Microsoft SQL Server 2022. This update contains 11 fixes that were issued after the release of SQL Server 2022 Cumulative Update 19 and it updates components in the following builds:

• SQL Server - Product version: 16.0.4205.1, file version: 2022.160.4205.1
• Analysis Services - Product version: 16.0.43.247, file version: 2022.160.43.247

Known issues in this update

Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.

Improvements and fixes included in this update

A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Select to download this Excel file now.

Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.

For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following table:

| Bug reference | Description | Fix area | Component | Platform |
| 4295018 | Fixes an infrequent race condition in which proactive caching register notification in multidimensional mode might cause a SQL Server Analysis Services (SSAS) server to stop responding during startup. | Analysis Services | Analysis Services | Windows |
| 4100859 | Fixes an assertion failure (Location:"sql\ntdbms\storeng\dfs\manager\blobaccess.cpp":9441; Expression:filepos > protocolHandler->m_maxFilePosSoFar) that you encounter when backing up to S3-compatible object storage fails and then having 20 retries. | SQL Server Engine | Backup Restore | All |
| 4123934 | Fixes a deadlock issue that results in a non-yielding scheduler and causes the SQL Server instance to stop responding when control.alternatewritethrough is set to 1 under low vCPU conditions. | SQL Server Engine | Linux | Linux |
| 4297001 | Adds memory limit support for Control Groups (cgroups) v2 in Platform Abstraction Layer (SQLPAL). | SQL Server Engine | Linux | Linux |
| 4167049 | Fixes a non-yielding scheduler dump issue with qds!CDBQDS::AbortQdsBackgroundTask that may occur when the list of Query Store (QDS) background tasks is large and either QDS is disabled or SQL Server shuts down. In addition to the dump, you would see the following error messages: Error: 1222, Severity: 16, State: 111. Lock request time out period exceeded. Error: 12412, Severity: 16, State: 1. Internal table access error: failed to access the Query Store internal table with HRESULT: 0x80004005 | SQL Server Engine | High Availability and Disaster Recovery | All |
| 4257781 | Fixes an issue in which uninitialized memory is returned in some rare cases when using limited length parameters with REPLACE function. | SQL Server Engine | Programmability | All |
| 4277598 | Fixes an issue in which an access violation dump occurs instead of returning the correct error message when using PARSE or TRY_PARSE with special floating-point values such as NaN (Not-a-Number) or Infinity as input. | SQL Server Engine | Programmability | All |
| 4053244 | Fixes an issue in which uninitialized memory can be read in some rare cases when using variable length parameters. | SQL Server Engine | Query Execution | All |
| 4104525 | Fixes an access violation that you encounter when a query calls a multi-statement table-valued function (MSTVF) that has a common language runtime (CLR) expression in its parameter and triggers interleaved execution. | SQL Server Engine | Query Optimizer | All |
| 4317961 | Adds support for "WITH SID=sid, TYPE=[E|X]" in the CREATE USER syntax in SQL Server 2022 by using trace flag 11953. For more information, see CREATE USER (Transact-SQL). | SQL Server Engine | SQL Server Engine | All |
| 4044263 | Fixes an issue introduced by a previous Windows update that causes restarts and even prevents setup from continuing. After applying this fix, the value of the PendingFileRenameOperations registry key is deleted when applying updates to SQL Server. | SQL Setup | Patching | Windows |

How to obtain or download this or the latest cumulative update package

File information

Notes for this update

How to uninstall this update

References

Original source Report a problem

This article describes Cumulative Update package 19 (CU19) for Microsoft SQL Server 2022. This update contains 13 fixes that were issued after the release of SQL Server 2022 Cumulative Update 18 and it updates components in the following builds:

• SQL Server - Product version: 16.0.4195.2, file version: 2022.160.4195.2
• Analysis Services - Product version: 16.0.43.244, file version: 2022.160.43.244

Known issues in this update

Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.

Improvements and fixes included in this update

A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017. Select to download this Excel file now.

Note
Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.

For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following Microsoft Knowledge Base articles.

Improvements and fixes included in this update table:

• 3717029: Fixes an issue in which the SQL Server Analysis Services (SSAS) service stops responding and the model is damaged when you add too many members (for example, more than 1,820 members) to a database role. (Analysis Services, Windows)
• 4110180: Fixes an issue in which using BACKUP TO URL for S3-compatible storage fails because the buffer for the multipart upload response is insufficient due to XML namespace clutter. (SQL Server Engine, Backup Restore, All)
• 4009999: Fixes a Microsoft Entra authentication issue for SQL Server on Linux with IPv6 enabled. The network.ipv6dnsrecordslimit mssql-conf option is added to limit the number of AAAA records returned by Domain Name System (DNS) to values between 0 and 5 (inclusive). After enabling this option, at least one IPv4 address will be tried to connect to Entra servers. For more information, see Microsoft Entra ID configuration options. (SQL Server Engine, Linux)
• 4020612: Fixes an issue that affects Red Hat Enterprise Linux (RHEL) 9 in which the encrypted connection fails due to an OpenSSL version upgrade. (SQL Server Engine, Linux)
• 3855044: Fixes an assertion failure (Location: op_decod.cpp:9532; Expression: false) that you encounter when running a query with a linked server. (SQL Server Engine, Query Execution, All)
• 2766519: Enables trace flag 9135 (TRCFLG_QP_DONT_USE_INDEXED_VIEWS) in retail builds to allow the EXPAND VIEWS behavior without the per-query hint. (SQL Server Engine, Query Optimizer, All)
• 4013356: Fixes an issue in which incorrect results might be returned if using WINDOW clauses in conjunction with CASE statements. (SQL Server Engine, Query Optimizer, All)
• 4021026: Fixes an issue that you encounter when a large number of full-text fragments are marked for deletion by dropping fragments in batches. (SQL Server Engine, Search, All)
• 3402292: Fixes an issue in which the server audit created in a contained availability group doesn't work after the SQL Server instance restarts. (SQL Server Engine, Security Infrastructure, All)
• 3979473: Enables the SERVER_OBJECT_PERMISSION_CHANGE_GROUP action group to audit associated actions. (SQL Server Engine, Security Infrastructure, All)
• 3873130: Fixes non-yielding exceptions that you might encounter when the Service Broker queue becomes very long while sending messages (for example, due to an application not properly closing conversations). (SQL Server Engine, Service Broker, All)
• 4013480: Reverts to the 2-GB limit for the minidump file size to avoid dump issues when capturing minidump files on SQL Server instances with a large amount of memory. (SQL Server Engine, SQL OS, Windows)
• 4048867: Updates the log tail file name to be constructed according to the dump file name after running the DBCC STACKDUMP command. (SQL Server Engine, SQL OS, Windows)

Original source Report a problem