Release notes for SQL Server Management Studio (SSMS) 19 (Preview)

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

To view the latest general availability (GA) version of SSMS release notes, visit SSMS Release Notes.

This article provides details about updates, improvements, and bug fixes for the current and previous versions of SSMS.

Note

In December 2021, releases of SSMS prior to 18.6 will no longer authenticate to Database Engines through Azure Active Directory with MFA. To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later.

Connectivity to Azure Analysis Services through Azure Active Directory with MFA requires SSMS 18.5.1 or later.

Current SSMS preview release

Download SQL Server Management Studio (SSMS) 19

SSMS 19 Preview 3 is the latest preview release of SSMS. If you need an earlier preview version of SSMS, see previous SSMS previews.

19.0 Preview 3

  • Release number: 19.0 Preview 3
  • Build number: 16.0.19061.0
  • Release date: August 11, 2022

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new in 19.0 Preview 3

New Item Details
Azure Data Studio installation integration Installation of SSMS installs Azure Data Studio 1.38.
Object Explorer Dropped Columns folder now exists under the Columns folder for Ledger tables, which have been altered to remove one or more columns.
Scripting Compatibility level defaults to 160 when scripting.
Showplan Added support for Hyperscale Optimized Query Processing.
SNAC Removal All references to SNAC have been removed from SSMS in compliance with its upcoming end of life.

Bug fixes in 19.0 Preview 3

Note

Fixes from SSMS 18.12 and the next SSMS release are included in SSMS 19.0 Preview 3.

New Item Details
Accessibility Fixed accessibility issue when navigating in the data classification window.
Analysis Services Connection to Analysis Services is now available.
Copy Database Wizard Fixed the log provider type error, which occurred when copying a database using The SQL Management Object method.
Replication Fixed error "Merge publications can't be created from this database until the compatibility level is set to 70 or higher." when using the publication wizard to create a new merge publication.
SqlParser Added missing options for CREATE USER and CREATE LOGIN.
SSIS The "Schedule..." menu item is now visible in the Azure SSIS Catalog.
XEvents Fixed an issue where reading target data for event sessions whose name overlaps with another session name caused data from the incorrect event session to appear in the viewer.

Known issues 19.0 Preview 3

New Item Details Workaround
Azure SQL DB Limitation with MSAL caching, which may require reauthentication when signing into Azure. Reauthenticate if prompted.
Database Designer Clicking the Design option for a view that references a table using spatial data causes SSMS to crash. Use T-SQL to make changes to the view.
Ledger Importing a bacpac or dacpac created from a database with the LEDGER = ON option, into a new database on-premises, fails due to the LEDGER property not being set. Use backup and restore to create a new database on-premises with the LEDGER property enabled.
Maintenance Plan The Maintenance Plan node isn't available in Object Explorer. Use SSMS 18.11.1 to view or edit Maintenance Plans.
SQL Managed Instance Viewing database properties for a SQL MI database may return the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (.Net SqlClient Data Provider)". There is a known problem due to incorrect data in msdb. To resolve, remove backup history. For example EXEC msdb..sp_delete_backuphistory @oldest_date = '<current date>'.
SSIS Trying to connect to SSIS, or running the upgrade wizard in SSIS, generates an error message. "The 'MSOLEDBSQL19' provider isn't registered on the local machine. (MsDtsSrvr)" Install the Microsoft OLE DB Driver 19 for SQL Server (x64) and Microsoft ODBC Driver 18 for SQL Server (x64) if using SSIS; this will be resolved in a later preview of SSMS 19.
Registered Servers SSMS 19 can't share a registered servers XML file with SSMS 18.x and earlier. Don't edit registered servers in SSMS 19, or don't use registered servers in SSMS 18.x and earlier after editing them in SSMS 19.
Storage Account Trying to delete a container from a storage account fails with a (400) Bad Request error. Use the Azure portal for container deletion.
Stretch DB Removed Stretch DB Wizard. Use T-SQL or an earlier version of SSMS (18.9.1 or below) to use the Stretch DB Wizard.

Previous SSMS previews

Download previous SSMS previews by selecting the download link in the related section.

SSMS version Build number Release date
19.0 Preview 2 16.0.19056.0 May 24, 2022

19.0 Preview 2

  • Release number: 19.0 Preview 2
  • Build number: 16.0.19056.0
  • Release date: May 24, 2022

Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

What's new in 19.0 Preview 2

New Item Details
Azure Data Studio installation integration Installation of SSMS installs Azure Data Studio 1.36.2.
Always Encrypted Added the ability to explicitly configure an attestation protocol in the "Connect To Server" dialog when using Always Encrypted with secure enclaves (column encryption).
Client Driver Changed to Microsoft.Data.SqlClient.
Contained Always On Availability Group Added support for Contained Always On Availability Groups.
Data Classification Improvements to Data Classification user interface.
Ledger Added support for Ledger feature Database ledger. For more information, visit What is the database ledger?.
Query Execution or Results Improved checks for open connections.
Query Tuning Assistant Updated user interface for improved accessibility.
Showplan The showplan XML schema has been updated.

Bug fixes in 19.0 Preview 2

Note

Fixes from SSMS 18.11.1 and the next SSMS release are included in SSMS 19.0 Preview 2.

New Item Details
Availability Group Dashboard Fixed the issue when connecting to the Availability Group Dashboard for an AG on SQL Server 2016, which resulted in "unknown property ClusterType" error.
Query Editor Fixed issue with audible notification occurring when closing a query window. See SSMS 18.11.1 Beeps When I Close a Query Window.

Known issues 19.0 Preview 2

New Item Details Workaround
Analysis Services Connection to Analysis Services isn't available. This will be available in a later preview, use SSMS 18.11.1 to connect to Analysis Services.
Azure SQL DB Limitation with MSAL caching, which may require reauthentication when signing into Azure. Reauthenticate if prompted.
Copy Database Wizard Copying a database generates a log provider type error Copy the database using an alternative method such as backup and restore to a new database.
Database Designer Clicking the Design option for a view that references a table using spatial data causes SSMS to crash. Use T-SQL to make changes to the view.
Ledger Importing a bacpac or dacpac created from a database with the LEDGER = ON option, into a new database on-premises, fails due to the LEDGER property not being set. Use backup and restore to create a new database on-premises with the LEDGER property enabled.
Maintenance Plan The Maintenance Plan node isn't available in Object Explorer. This will be available in a later preview, use SSMS 18.11.1 to view or edit Maintenance Plans.
SSMS Installer The original installation of Japanese SSMS wasn't fully localized and removed from the download page. This is fixed via an updated build, 16.0.19058.0, now available for download.
Storage Account Trying to delete a container from a storage account fails with a (400) Bad Request error. Use the Azure portal for container deletion.
Stretch DB Removed Stretch DB Wizard. Use T-SQL or an earlier version of SSMS (18.9.1 or below) to use the Stretch DB Wizard.

You can reference SQL Server user feedback for other known issues and to provide feedback to the product team.

Next steps

For a list of all SQL Server Management Studio downloads, search the Microsoft Download Center.

For the latest preview of SQL Server Management Studio 19.0, see Download SQL Server Management Studio (SSMS).