Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
KB5028743 - Cumulative Update 7 for SQL Server 2022
Release Date: August 10, 2023
Version: 16.0.4065.3
Summary
This article describes Cumulative Update package 7 (CU7) for Microsoft SQL Server 2022. This update contains 20 fixes that were issued after the release of SQL Server 2022 Cumulative Update 6, and it updates components in the following builds:
- SQL Server - Product version: 16.0.4065.3, file version: 2022.160.4065.3
- Analysis Services - Product version: 16.0.43.221, file version: 2022.160.43.221
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 | Description | Fix area | Component | Platform |
|---|---|---|---|---|
| 2469661 | Fixes an issue in which the validation of a custom input mask fails. After applying this fix, you can use a custom input mask with the time part. | Master Data Services | Master Data Services | Windows |
| 2516796 | Fixes an issue in which you can't see the Created By and Updated By fields in the View History window when you use the Master Data Services (MDS) Add-in for Excel. | Master Data Services | Master Data Services | Windows |
| 2518605 | Fixes an issue in which an error may occur when you download an attachment uploaded previously in a Master Data Services model. | Master Data Services | Master Data Services | Windows |
| 2500053 | Fixes an access violation in sqllang!FReadDataDirect that you encounter during network exchanges between an instance of SQL Server and a client. |
SQL Connectivity | SQL Connectivity | All |
| 1550865 | Fixes an issue in which the BACKUP or RESTORE statement doesn't time out even after a long time when the S3 server is unreachable or the hostname/IP address/port number that's given in the URL is incorrect. After applying this fix, backing up or restoring a database to the S3 server fails quickly. |
SQL Server Engine | Backup Restore | All |
| 2491363 | Fixes an issue in which a checkpoint process on an In-Memory OLTP database may get stuck, and the log size keeps increasing. | SQL Server Engine | In-Memory OLTP | All |
| 2369109 | FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 (KB4538581) | SQL Server Engine | Programmability | All |
| 2423760 | Fixes the following SQL Server assertion failure: Error: 17065, Severity: 16, State: 1. Server Assertion: File: <typinfo.cpp>, line = 1153 Failed Assertion = 'false' Invalid comparison due to NO COLLATION. |
SQL Server Engine | Programmability | All |
| 2528280 | Fixes a dump issue that you encounter when you run the APPROX_COUNT_DISTINCT query, which affects the query that has at least two approximate count aggregates where at least one aggregate is on a char column and the char column isn't the first aggregate in the query. |
SQL Server Engine | Programmability | All |
| 2512016 | Fixes an access violation that you encounter during the initialization of Query Store if a parameter sensitive plan (PSP) optimization query variant has inconsistent data within the Query Store. | SQL Server Engine | Query Execution | All |
| 2458680 | Fixes a manual cleanup issue in which the repeated lock escalations on the tables cause contention and slowness in cleaning up the expired change tracking metadata. Note: You need to turn on trace flag 8284. |
SQL Server Engine | Replication | All |
| 2506726 | Improves sp_addpublication_snapshot by exposing additional parameters (@distributor_security_mode, @distributor_login, and @distributor_password). With these parameters, you can configure the Snapshot Agent to connect to the Distributor using SQL Server Authentication. Before this fix, the Snapshot Agent connects to the Distributor with Windows Authentication, and you can't configure it to connect to the Distributor using SQL Server Authentication. |
SQL Server Engine | Replication | All |
| 2491020 | Fixes an issue in which running sp_change_users_login reports the following error if the database collation is Chinese_PRC_CI_AS: Msg 9833, Level 16, State 3, Line <LineNumber> Invalid data for DBCS-encoded characters. |
SQL Server Engine | Security Infrastructure | All |
| 2522765 | Fixes the incorrect masking behavior that you encounter when you use an INSTEAD OF trigger that's defined on a table, which contains columns that use dynamic data masking (DDM). |
SQL Server Engine | Security Infrastructure | All |
| 2526528 | Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses dynamic data masking (DDM). | SQL Server Engine | Security Infrastructure | All |
| 2494984 | Fixes a memory leak issue that you encounter on MEMOBJ_STORAGEMANAGEMENT when you try to use Backup TO URL for AWS S3-compatible object storage. |
SQL Server Engine | SQL OS | All |
| 2475019 2568409 |
Improvement: Make several enhancements to the SQLIOSim utility (KB5028786) | SQL Server Engine | Storage Management | All |
| 2337613 | Fixes an issue in which running DBCC CHECKTABLE may create snapshot files, even if a user fails the table-level permission check. |
SQL Server Engine | Storage Management | All |
| 2491770 | Fixes an issue in which the number of the Log Writer threads is inconsistent when the SQL Server instance is affinitized to a subset of NUMA nodes. | 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
Feedback
Was this page helpful?