We know many of you have been looking forward to this release, and we appreciate your patience.
Please note that if you have an earlier release of SSMS (e.g., 18.x), you can install 19.0 side-by-side with that version. Within Tools > Options > Query Execution, simply uncheck the option 'Check for open transactions before closing T-SQL query windows'.įor those who installed a preview version of SSMS 19 (thank you!), it's recommended to uninstall that version before installing SSMS 19.0. Therefore, in SSMS 19.0 you have the ability to disable to dialog box completely. In 18.12, we added an option to cancel the check if it took more than two seconds, but user comments indicated that was not enough. In addition, we received a lot of feedback about the dialog box, 'Querying transaction count', we introduced back in SSMS 18.11. Removal of dependency on SQL Server Native Client (SNAC).Improvements to the Link feature for Azure SQL Managed Instance.Support for Contained Availability Groups.
You can review the entire list of new functionality and fixes in the release notes, but we'd like to call out a few highlights here: This is the recommended release for SQL Server 2022, and it includes support for combability level 160. The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!
