SQL Server Management Studio (SSMS) 19.0 Released!

Microsoft

Jan 26, 2023

The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!

This is the recommended release for SQL Server 2022, and it includes support for combability level 160. 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:

Improved support and additional options for Azure Active Directory Authentication
Migrated to Microsoft.Data.SqlClient (MDS) from System.Data.SqlClient (SDS)
Support for Contained Availability Groups
Support for Ledger
Improvements to the Link feature for Azure SQL Managed Instance
Removal of dependency on SQL Server Native Client (SNAC)
Installation of Azure Data Studio 1.41

In addition, we received a lot of feedback about the dialog box, "Querying transaction count", we introduced back in SSMS 18.11. 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. Therefore, in SSMS 19.0 you have the ability to disable to dialog box completely. Within Tools > Options > Query Execution, simply uncheck the option "Check for open transactions before closing T-SQL query windows".

For those who installed a preview version of SSMS 19 (thank you!), it's recommended to uninstall that version before installing SSMS 19.0. 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.

We know many of you have been looking forward to this release, and we appreciate your patience. Please know that we do monitor the feedback you all provide, and items that have steps to recreate (in the case of bugs), real-world examples (in the case of requests), constructive comments, and upvotes are extremely helpful to us. We have a few tasks to finish up, including making a standalone download for Distributed Replay available, but know that we are already planning for the next release. We look forward to hearing from you, whether you just want to be on the latest version of SSMS, or you're upgrading to SQL 2022. And if it's the latter, good luck with your upgrade, and as always, test your backups!

Updated Feb 03, 2025

Version 2.0

SQLServer2022

sqltools

erinstellato

Microsoft

Joined February 24, 2022

View Profile

SQL Server Blog

Follow this blog board to get notified when there's new activity

erinstellato
Microsoft
Nov 28, 2023
For general awareness, we released SSMS 19.2 on November 13 (download here), and it addresses a few of the issues mentioned in the comments on this post (e.g. several of the replication ones). Please see the release notes for complete details. Thanks.
PatSimo
Copper Contributor
Oct 02, 2023
Hi @erinstellato

You misunderstood me, I already opened this bug by myself in April: VS2022 SQL debugging - buggy command line pointer or breakpoint line

But unfortunately nobody from the Microsoft Team reacted on this thread.
Perhaps you know someone from the SQL debugger Team and you could point them to this bug?

Thanks,
Pat
erinstellato
Microsoft
Sep 29, 2023
Hi PatSimo - you can report bugs for Visual Studio through the tool, details here: Report a problem with Visual Studio - Visual Studio (Windows) | Microsoft Learn

luistorres SSMS 19 is still 32 bit. As I've noted in the most recent post about SSMS (SSMS 19.1 New Features (microsoft.com)) we will be migrating to the latest VS shell for SSMS 20, and that will get us to 64bit.
luistorres
Brass Contributor
Sep 29, 2023
Is SSMS 19 64 bits or 32 bits?
If it is 32 bits, Is Microsoft in the 64 bits version?
PatSimo
Copper Contributor
Aug 09, 2023
Hi Erin,

I found another bug while debugging a SP in Visual Studio 2022: VS2022 SQL debugging - buggy command line pointer or breakpoint line
Maybe you know someone in the SQL debugger team to take a look on it...?

Thanks,
Patrick
albertozgz
Copper Contributor
Jul 12, 2023
erinstellato

"Error loading adal.dll" (SSMS 19.1.56)

Hello
For the Import / Export wizard of SSMS
To connect to Azure Database with 2FA, you need Choose "Microsoft OLE DB Driver for SQL Server"

Unfortunately, looks like ADAL libraries has been deprecated on Dec 2022

As far as I know any of the other drivers are compatible with Az DB & AAD 2FA:

am I missing something?
NeilK-PDC
Copper Contributor
Jul 11, 2023
Came across PatSimo's problem, too. Working with SQL Server 2017. Installed 18.12.1 to get things working.

PatSimo

Copper Contributor

Jun 19, 2023

Hi Erin,

I just encountered a new bug with SSMS 19.1:

This when adding a new merge replication subscriber (pull subscription), after entering the subscriber sql login informations.

===================================

Property Password cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionSettings.ThrowIfConnectionStringIsSet(String propertyName)
at Microsoft.SqlServer.Management.Common.ConnectionSettings.set_SecurePassword(SecureString value)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.Initialize(UIConnectionInfo conninfo, SqlConnection sqlconn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection..ctor(UIConnectionInfo conninfo, SqlConnection sqlconn)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.ShowDialogValidateConnection(UIConnectionInfo& connInfo, Form parent, Boolean fixedServerName)
at Microsoft.SqlServer.Management.UI.PageChooseSubscribers.AddSqlSubscriber()
at Microsoft.SqlServer.Management.UI.PageChooseSubscribers.btnAddServer_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

I tried SSMS 17.9.1 afterwards and this version works correctly.

Thanks,

Patrick

erinstellato
Microsoft
Jun 09, 2023
Hi @Vineroi we have recreated this issue with SSMS 19.x against SQL Server 2017 (it doesn't happen with 2022) and I have logged an issue for it internally. Thank you for reporting it, we will get it fixed in a future release. As a workaround (less than ideal I know), you can use 18.12.1
Vinceroi
Copper Contributor
Jun 08, 2023
Hi Erin Stellato

I am mainly connecting to SQL Server 2017.

Thanks for your support!
Vincent

Blog Post

SQL Server Management Studio (SSMS) 19.0 Released!