SQL Server 2022 Updates & Release Notes

This article describes Cumulative Update package 25 (CU25) for Microsoft SQL Server 2022. This update contains 11 fixes that were issued after the release of SQL Server 2022 Cumulative Update 24. It updates components in the following builds:

• SQL Server - Product version: 16.0.4255.1, file version: 2022.160.4255.1
• Analysis Services - Product version: 16.0.43.252, file version: 2022.160.43.252

Important

To help secure SQL Server on Windows, enable encryption with Extended Protection.

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

• 4954485 - Fixes an issue in Contained Availability Groups in which DatabaseMail sends email messages without attachments. - SQL Server Client Tools - Database Mail - All
• 4999187 - Fixes an issue in which permissions on stored procedures and other objects in msdb are lost during the SQL Server upgrade process. This issue causes users to lose granted permissions. - SQL Server Engine - Management Services - Windows
• 5028794 - Fixes an access violation error that occurs when querying sys.dm_xe_session_targets on SQL Server instances that are running on Windows Server 2025. - SQL Server Engine - SQL OS - Windows
• 5033534 - Fixes an issue in Contained Availability Group connections in which T-SQL allows only adding a database to the currently connected Contained Availability Group, and also causes additional restrictions for DBCreator roles. - SQL Server Engine - High Availability and Disaster Recovery - All
• 5034739 - Fixes a memory leak issue in which parallel execution of SHORTEST_PATH queries in Graph databases causes persistent OBJECTSTORE_SOSTASK growth. - SQL Server Engine - Query Optimizer - All
• 5090699 - Fixes an issue in which a self-assignment update on a small off-row XML column by having compression enabled causes XML data corruption and a subsequent transport-level error when selecting the data. - SQL Server Engine - Access Methods - All
• 5126699 - Fixes an issue in which using the Oracle ODBC driver together with the ODBC connector in SSIS packages might cause heap corruption and data loss. - Integration Services - Integration Services - All
• 5130873 - Fixes a heap corruption issue in the generic ODBC connector when using the Oracle ODBC driver. - Integration Services - Integration Services - All
• 5131000 - Fixes an XML External Entity (XXE) vulnerability in the Web Service Task by blocking the file:// protocol in WSDL service endpoints to prevent unauthorized file access and denial-of-service attacks. - Integration Services - Integration Services - Windows
• 5157137 - Fixes CPU starvation issues by adding yields at regular intervals during in-memory OLTP garbage collection scan of hash indexes. - SQL Server Engine - In-Memory OLTP - All
• 5213660 - Fixes a back-up cleanup issue on Linux that could cause SQL Server to stop responding when a network share becomes full or unreachable. - SQL Server Engine - Linux - Linux

Original source

KB5080999 - Cumulative Update 24 for SQL Server 2022

Applies to: SQL Server 2022 on Windows, SQL Server 2022 on Linux

Release Date: March 12, 2026
Version: 16.0.4245.2

Summary

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

• SQL Server - Product version: 16.0.4245.2, file version: 2022.160.4245.2
• Analysis Services - Product version: 16.0.43.252, file version: 2022.160.43.252

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.

Improvements and fixes included in this update (table)

• 4838719 — Fixes an issue in StripedVdiTests to improve test reliability and stability. — SQL Server Engine — Backup Restore — Windows
• 4868211 — Adds a new optional parameter, @multi_subnet_failover, to sp_adddistributor. — SQL Server Engine — Replication — All
• 4874339 — Fixes an issue that occurs when creating or restoring a database on a contained availability group connection. — SQL Server Engine — High Availability and Disaster Recovery — All
• 4911747 — Fixes an issue in the in-memory sort buffer calculation that causes an infinite loop when the required page count exceeds supported limits. — SQL Server Engine — Backup Restore — All
• 4917971 — Fixes a floating point exception that occurs when switching from a Hekaton to a non-Hekaton stack. This action causes query execution to break. — Hekaton — Query Processing — All
• 4931278 — Fixes an issue in which a sort operation on a rowset that's larger than four billion rows fails and generates an assertion error. — SQL Server Engine — Access Methods — All
• 4931830 — Fixes an issue in which the distributor is part of an availability group (AG) and uses case-sensitive (_CS) collation. The distribution agent incorrectly uses the AG primary replica name instead of the AG listener name. — SQL Server Engine — Replication — All
• 4953763 — Fixes an issue in which the configure-only replica of a Contained Availability Group cannot be connected after a restart because of a startup failure. — SQL Server Engine — High Availability and Disaster Recovery — All
• 4955136 — Fixes an issue that occurs when using a local monitor server for Log Shipping and Contained Availability Group after failover. — SQL Server Engine — High Availability and Disaster Recovery — All
• 4955493 — Fixes a typo in sys.dm_os_linux_disk_stats by correcting ios_in_progess to ios_in_progress. — SQL Connectivity — Linux — Linux
• 4976761 — Fixes an issue in which altering a disabled DDL trigger causes a memory access violation. — SQL Server Engine — Programmability — All
• 4984502 — Adds a configurable full-text search batch timeout by using sp_fulltext_service 'batch_timeout'. Specify a value between one minute and one hour, in milliseconds. By default, batches time out after 10 minutes if there are no progress updates. — SQL Server Engine — Search — All
• 5005885 — Addresses contention on security-related metadata tables by adding sysowners to frequently accessed metadata tables check. — SQL Server Engine — Security Infrastructure — All
• 5011606 — Adds support for symbolic links in the getattribute API. — SQL Server Engine — Linux — Linux
• 5011720 — Adds a configuration option to add Bulkadmin operations to the allowlist. — SQL Server Engine — Linux — Linux

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

File information

Notes for this update

Prerequisites

Restart information

Registry information

Important notices

Hybrid environment deployment

Language support

Components (features) updated

Support for this update

How to uninstall this update

• How to uninstall this update on Windows
• How to uninstall this update on 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

Original source

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

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

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

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

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

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

• SQL Server - Product version: 16.0.4185.3, file version: 2022.160.4185.3
• Analysis Services - Product version: 16.0.43.242, file version: 2022.160.43.242

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.

• Bug reference 2998962: Fixes an issue in which a copy-only filegroup backup on an availability group secondary replica fails with the following errors: Msg 3059, Level 16, State 1, Line This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. Msg 3013, Level 16, State 1, Line BACKUP DATABASE is terminating abnormally.
• Bug reference 3726420: Makes the contained availability group (AG) available to use resource governor workload group that's defined at the instance level. For more information, see Resource governor.
• Bug reference 3691969: Fixes a race condition that you encounter during flush operations when configuring control.alternatewritethrough = 1, which causes extended waits for some transactions.
• Bug reference 3867855: Fixes an issue in which a self-signed certificate created for SQL Server on Linux might include a negative serial number.
• Bug reference 3791615: Fixes an issue in Database Mail in which the information logged into the sysmail_log system table and sysmail_event_log view in the msdb database might be stored and displayed as "???" (for example, when querying objects in SSMS). This issue might happen when the reported message (typically an error condition) contains non-ASCII characters and is more common on localized versions of SQL Server (for example, Japanese), not specific to the language of the SQL Server instance or its collation.
• Bug reference 3848607: Fixes an issue in which the sys.computed_columns view doesn't show the proper definition when using external tables with file metadata columns.
• Bug reference 3802029: Fixes an issue in which the manual change tracking cleanup stored procedure incorrectly sets the invalid cleanup version to negative when the TableName parameter isn't passed.
• Bug reference 3821559: Fixes an issue in which the second article might not have updates correctly replicated if accelerated database recovery (ADR) is enabled on the database using replication with two articles for a single table.
• Bug reference 3902839: Fixes incorrect results that you encounter when you create a full-text index for a .docx file that contains a hyperlink at the start of a paragraph but without a trailing whitespace at the end of the previous paragraph, which causes the full-text search to fail to correctly index the contents of the hyperlink. Note: You need to turn on trace flag 7686.
• Bug reference 3549792: Fixes an error that you encounter when the 'Erase Phantom System Health Records' step in the SQL Server Agent job syspolicy_purge_history tries to connect to other instances and the account running the service doesn't have permission to connect. The following error occurs in the SQL Server error log: Logon Error: 18456, Severity: 14, State: 5. Logon Login failed for user ''. Reason: Could not find a login matching the name provided. [CLIENT: ]
• Bug reference 3800647: Data Quality Services (DQS) is only supported in SQL Server Enterprise and Developer editions. Before the fix, the operation is completed successfully when you try to install DQS in the Standard or Web edition. Moreover, this DQS will automatically be selected for installation when setting up a Windows Server Failover Cluster. Once installed, this DQS can't be configured. After applying this fix, SQL Server Setup won't allow DQS to be installed in SQL Server Standard or Web edition. Note: This fix applies to new installations only. For more information, see Installing Updates from the Command Prompt.

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

KB5048038 - Cumulative Update 17 for SQL Server 2022

Applies to: SQL Server 2022 on Windows, SQL Server 2022 on Linux

Release Date: January 16, 2025

Version: 16.0.4175.1

Summary

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

• SQL Server - Product version: 16.0.4175.1, file version: 2022.160.4175.1
• Analysis Services - Product version: 16.0.43.239, file version: 2022.160.43.239

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:

• 3666640: Fixes an issue with the business rule item for the domain-based attribute (DBA) option when you use Master Data Services. (Master Data Services, Windows)
• 3560259: Fixes an issue in which some availability group (AG) databases are in a non-synchronized state after the Windows Server Failover Clustering (WSFC) quorum loss. After applying the fix, the databases should be able to switch to a resolving state when the persisted configuration data can't be read because of the WSFC quorum loss. (SQL Server Engine, High Availability and Disaster Recovery, All)
• 3615657: Adds trace flag 3478 in SQL Server 2022 to allow the maximum number of parallel redo threads to be increased based on the total number of CPUs. This change aims to restore the same functionality as SQL Server 2016 or later versions if the thread pool is disabled in SQL Server 2022. (SQL Server Engine, High Availability and Disaster Recovery, All)
• 3677296: Starting in SQL Server 2022 CU17, you can enable Always On availability groups by using a Pacemaker cluster when SQL Server runs as a restricted application with Security-Enhanced Linux (SELinux) enabled. (SQL Server Engine, High Availability and Disaster Recovery, Linux)
• 3086691: Adds a server configuration option external xtp dll gen util enabled, which is configured by using sp_configure to enable the Hekaton dynamic-link library (DLL) Generator component for the Hekaton (In-Memory OLTP) feature. SQL Server compiles and links a DLL for each native compiled table and stored procedure, which contains the native implementation of those objects in C code. Although the Hekaton DLLs are dynamically generated, the files themselves might present some challenges when there's a compliance requirement that enforces code integrity as a criterion. With the introduction of the Hekaton DLL Generator component for the Hekaton (In-Memory OLTP) feature, regulatory compliance requirements such as code integrity can be met with Hekaton-generated DLLs. In this case, code integrity ensures that the Hekaton-generated DLLs remain intact and unmodified from the time they're created until they're loaded and executed. (SQL Server Engine, In-Memory OLTP, Windows)
• 3677980: FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 (KB4538581) (SQL Server Engine, Programmability, All)
• 3653362: Fixes a performance issue of the SUBSTRING function that you encounter when extensively using the function, such as building indexes on computed columns with expressions that involve calling SUBSTRING. (SQL Server Engine, Programmability, All)
• 3572259: Fixes error "The XML data type is damaged" thrown by the Replication Log Reader Agent when you update an XML column with XML compression enabled. (SQL Server Engine, Replication, Windows)
• 3445709 3538141 3686639: Improvement: Microsoft Entra managed identity support for backup and restore database operations and for EKM with AKV in SQL Server on Azure VMs (KB5043526) (SQL Server Engine, Security Infrastructure, Windows)
• 3514753: Fixes various assertion failures (for example, Location: sosmerge.cpp:2930; Expression: mrP->mrpgcnt > 0) that you might encounter when building an index in simple or bulk-logged recovery models with indirect checkpoints because of missing flushes of intermediate data pages. (SQL Server Engine, SQL OS, All)
• 3616559: Fixes a performance issue that you might encounter only when sp_lock is called frequently from multiple connections, which might cause a memory leak. The memory isn't cleaned up until you restart the SQL Server service. Note: You need to turn on trace flag 15915. (SQL Server Engine, Transaction Services, All)

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

File information

Notes for this update

How to uninstall this update

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

Original source