Crashes and freezes Fixed a source of common SSMS crashes related to GDI objects.

Crashes and freezes Fixed a common source of hangs and poor performance when selecting "Script as Create/Update/Drop" (removed unnecessary fetches of SMO objects).

Crashes and freezes Fixed an issue where system stops responding when connecting to an Azure SQL Database using MFA while ADAL traces are enabled.

Crashes and freezes Fixed a issue where system stops responding (or perceived hang) in Live Query Statistics when invoked from Activity Monitor (the issue manifested when using SQL Server authentication with no "Persist Security Info" set).

Crashes and freezes Fixed a issue where system stops responding when selecting "Reports" in Object Explorer, which could manifest on high latency connections or temporary non-accessibility of the resources.

Crashes and freezes Fixed a crash in SSMS when trying to use Central Management Server and Azure SQL servers. For details, see SMSS 17.5 application error and crash when using Central Management Server.

Crashes and freezes Fixed a issue where system stops responding in Object Explorer by optimizing the way IsFullTextEnabled property is retrieved.

Crashes and freezes Fixed a issue where system stops responding in "Copy Database Wizard" by avoiding to build unnecessary queries to retrieve Database properties.

Crashes and freezes Fixed an issue that was causing SSMS to stop responding/crash while editing T-SQL.

Crashes and freezes Mitigated an issue where SSMS was becoming unresponsive when editing large T-SQL scripts.

Crashes and freezes Fixed an issue that was causing SSMS to run out of memory when handling the large datasets returned by queries.

General SSMS Fixed an issue there the "ApplicationIntent" wasn't passed along in connections in "Registered Servers".

General SSMS Fixed an issue where the "New XEvent Session Wizard UI" form wasn't rendered properly on High DPI monitors.

General SSMS Fixed an issue where trying to import a bacpac file.

General SSMS Fixed an issue where trying to display the properties of a database (with FILEGROWTH > 2048 GB) was throwing an arithmetic overflow error.

General SSMS Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that couldn't found in subreports.

General SSMS Another round of fixes to make SSMS more multi-monitor aware by having it open dialog in the correct monitor.

Analysis Services (AS) Fixed an issue where the "Advanced Settings" to the AS XEvent UI was clipped.

Analysis Services (AS) Fixed an issue where DAX parsing throws file not found exception.

Azure SQL Database Fixed an issue where the database list wasn't populated correctly for Azure SQL Database query window when connected to a user database in Azure SQL Database instead of to master.

Azure SQL Database Fixed an issue where it wasn't possible to add a "Temporal Table" to an Azure SQL Database.

Azure SQL Database Enabled the Statistics properties sub menu option under menu Statistics in Azure, since it has been fully supported for quite some time now.

Azure SQL - General Support Fixed issues in common Azure UI control that was preventing the user from displaying Azure subscriptions (if there were more than 50). Also, the sorting has been changed to be by name rather by Subscription ID. The user could run into this one when trying to restore a backup from URL, for example.

Azure SQL - General Support Fixed an issue in common Azure UI control when enumerating subscriptions, which could yield an "Index was out of range. Must be non-negative and less than the size of the collection." error when the user had no subscriptions in some tenants. The user could run into this one when trying to restore a backup from URL, for example.

Azure SQL - General Support Fixed issue where Service Level Objectives were hardcoded, thus making it harder for SSMS to support newer Azure SQL SLOs. Now, the user can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size)

Azure SQL Managed Instance support Improved/polished the support for managed instances: disabled unsupported options in UI and a fix to the View Audit Logs option to handle URL audit target.

Azure SQL Managed Instance support "Generate and Publish scripts" wizard scripts unsupported CREATE DATABASE clauses.

Azure SQL Managed Instance support Enable Live Query Statistics for managed instances.

Azure SQL Managed Instance support Database properties->Files was incorrectly scripting ALTER DB ADD FILE.

Azure SQL Managed Instance support Fixed regression with SQL Agent scheduler where ONIDLE scheduling was chosen even when some other scheduling type was chosen.

Azure SQL Managed Instance support Adjusting MAXTRANSFERRATE, MAXBLOCKSIZE for doing backups on Azure Storage.

Azure SQL Managed Instance support The issue where tail log backup is scripted before RESTORE operation (this isn't supported on CL).

Azure SQL Managed Instance support Create database wizard not scripting correctly CREATE DATABASE statement.

Azure SQL Managed Instance support Special handling of SSIS packages within SSMS when connected to managed instances.

Azure SQL Managed Instance support Fixed an issue where an error was displayed while trying to use "Activity Monitor" when connected to managed instances.

Azure SQL Managed Instance support Improved support for AAD Logins (in SSMS Explorer).

Azure SQL Managed Instance support Improved scripting of SMO Filegroups objects.

Azure SQL Managed Instance support Improved UI for credentials.

Azure SQL Managed Instance support Added support for Logical Replication.

Azure SQL Managed Instance support Fixed an issue, which was causing right-clicking on a database and choosing 'Import data-tier application' to fail.

Azure SQL Managed Instance support Fixed an issue, which was causing right-clicking on a "TempDB" to show errors.

Azure SQL Managed Instance support Fixed an issue where trying to scripting ALTER DB ADD FILE statement in SMO was causing the generated T-SQL script to be empty.

Azure SQL Managed Instance support Improved display of managed instances server-specific properties (hardware generation, service tier, storage used and reserved).

Azure SQL Managed Instance support Fixed an issue where scripting of a database ("Script as Create...") wasn't scripting extra filegroups and files. For details, see https://feedback.azure.com/forums/908035/suggestions/37326799.

Backup/Restore/Attach/Detach DB Fixed an issue where the user was unable to attach a database when physical filename of .mdf file does not match the original filename.

Backup/Restore/Attach/Detach DB Fixed an issue where SSMS might not find a valid restore plan or might find one, which is suboptimal. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897752.

Backup/Restore/Attach/Detach DB Fixed issue where the "Attach Database" wizard wasn't displaying secondary files that were renamed. Now, the file is displayed, and a comment about it is added (for example "Not Found"). For details, see https://feedback.azure.com/forums/908035/suggestions/32897434.

Copy Database Wizard Generate scripts/Transfer/Copy Database Wizard try to create a table with an in memory table doesn't force ansi_padding on.

Copy Database Wizard Transfer Database task/Copy Database Wizard broken on SQL Server 2017 and SQL Server 2019. ""

Copy Database Wizard Generate scripts/Transfer/Copy Database Wizard script table creation before creation of associated external data source.

Connection dialog Enabled the removal of usernames from previous username list by pressing the DEL key. For details, see Allow deletion of users from SSMS login window.

DAC Import Wizard Fixed an issue DAC Import Wizard wasn't working when connected using AAD.

Data Classification Fixed an issue when saving classifications in the data classification pane while there are another data classification panes open on other databases.

Data-tier Application Wizard Fixed an issue where the user wasn't able to import a Data-tier Application (.dacpac) due to limited access to the server (for example, no access to all the databases on the same server).

Data-tier Application Wizard Fixed an issue, which was causing the import to be extremely slow when many databases happened to be hosted on the same Azure SQL server.

External Tables Added support for Rejected_Row_Location in template, SMO, intellisense, and property grid.

Flat File Import Wizard Fixed an issue where the "Import Flat File Wizard" wasn't handling double quotes correctly (escaping). For details, see https://feedback.azure.com/forums/908035/suggestions/32897998.

Flat File Import Wizard Fixed an issue where related to incorrect handling of floating-point types (on locales that use a different delimiter for floating points).

Flat File Import Wizard Fixed an issue related to importing of bits when values are 0 or 1. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898535.

Flat File Import Wizard Fixed an issue where the float data-type were entered as nulls.

Flat File Import Wizard Fixed an issue where the import wizard wasn't able to process negative decimal values.

Flat File Import Wizard Fixed an issue where the wizard wasn't able to import from single column CSV files.

Flat File Import Wizard Fixed issue where Flat File Import does not allow changing destination table when table is already existing. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186.

Help Viewer Improved logic around honoring the online/offline modes (there may still be a few issues that need to be addressed).

Help Viewer Fixed the "View Help" to honor the online/offline settings. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897791.

High Availability Disaster Recovery (HADR)

Availability Groups (AG) Fixed an issue where roles in "Fail Over Availability Groups" wizard was always displayed as "Resolving".

High Availability Disaster Recovery (HADR)

Availability Groups (AG) Fixed an issue where SSMS was showing truncated warnings in "AG Dashboard".

Integration Services (IS) Fixed a SxS issue that deployment wizard fails to connect to sql server when SQL Server 2019 and SSMS 18.0 are installed on the same machine.

Integration Services (IS) Fixed an issue that maintenance plan task can't be edited when designing the maintenance plan.

Integration Services (IS) Fixed an issue that the deployment wizard gets stuck if the project under deployment is renamed.

Integration Services (IS) Enabled environment setting in Azure-SSIS IR schedule feature.

Integration Services (IS) Fixed an issue that SSIS Integration Runtime Creation Wizard stops responding when the customer account belongs to more than 1 tenant.

Job Activity Monitor Fixed crash while using Job Activity Monitor (with filters).

Object Explorer Fixed an issue where SSMS was throwing an "Object cannot be cast from DBNull to other types" exception when trying to expand "Management" node in OE (misconfigured DataCollector).

Object Explorer Fixed an issue where OE wasn't escaping quotes before invoking the "Edit Top N..." causing the designer to get confused.

Object Explorer Fixed an issue where the "Import Data-Tier application" wizard was failing to launch from the Azure Storage tree.

Object Explorer Fixed an issue in "Database Mail Configuration" where the status of the TLS/SSL checkbox wasn't persisted. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32895541.

Object Explorer Fixed an issue where SSMS grayed out option to close existing connections when trying to restore database with is_auto_update_stats_async_on.

Object Explorer Fixed an issue where right-clicking on nodes in OE the (for example "Tables" and wanting to perform an action such as filtering tables by going to Filter > Filter Settings, the filter settings form can appear on the other screen than where SSMS is currently active). For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/34284106.

Object Explorer Fixed a long outstanding issue where the DELETE key wasn't working in OE while trying to rename an object. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/33073510, https://feedback.azure.com/forums/908035/suggestions/32910247 and other duplicates.

Object Explorer When displaying the properties of existing database files, the size appears under a column "Size (MB)" instead of "Initial Size (MB)" which is what is displayed when creating a new database. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32629024.

Object Explorer Disabled the "Design" context-menu item on "Graph Tables" since there is no support for those tables in the current version of SSMS.

Object Explorer Fixed an issue where the "New Job Schedule" dialog wasn't rendering properly on High DPI monitors. For details, see https://feedback.azure.com/admin/v3/suggestions/35541262.

Object Explorer Fixed/improved the way an issue where a database size ("Size (MB)") is displayed in Object Explorer details: only 2 decimal digits and formatted using the thousands separator. For details, see https://feedback.azure.com/forums/908035/suggestions/34379308.

Object Explorer Fixed an issue that was causing the creation of a "Spatial Index" to fail with an error like "To accomplish this action, set property PartitionScheme".

Object Explorer Minor performance improvements in Object Explorer to avoid issuing extra queries, when possible.

Object Explorer Extended logic to request confirmation when renaming a database to all the schema objects (the setting can be configured).

Object Explorer Added proper escaping in Object Explorer filtering. For details, see https://feedback.azure.com/forums/908035/suggestions/36678803.

Object Explorer Fixed/improved the view in Object Explorer Details to show numbers with proper separators. For details, see https://feedback.azure.com/forums/908035/suggestions/32900944.

Object Explorer Fixed context menu on "Tables" node when connected to SQL Express, where the "New" fly-out was missing, Graph tables were incorrectly listed, and System-Versioned table was missing. For details, see https://feedback.azure.com/forums/908035/suggestions/37245529.

Object Scripting Overall perf improvements - Generate Scripts of WideWorldImporters takes half the time compared to SSMS 17.7.

Object Scripting When scripting objects, DB Scoped configuration, which has default values are omitted.

Object Scripting Don't generate dynamic T-SQL when scripting. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898391.

Object Scripting Omit the graph syntax "as edge" and "as node" when scripting a table on SQL Server 2016 and earlier.

Object Scripting Fixed an issue where scripting of database objects was failing when connecting to an Azure SQL Database using AAD with MFA.

Object Scripting Fixed an issue where trying to script a spatial index with GEOMETRY_AUTO_GRID/GEOGRAPHY_AUTO_GRID on an Azure SQL Database was throwing an error.

Object Scripting Fixed an issue, which was causing the database scripting (of an Azure SQL Database) to always target an on-prem SQL, even if the "Object Explorer" scripting settings were set to match the source.

Object Scripting Fixed an issue where trying to script a table in a SQL DW database involving clustered and nonclustered indexes was generating incorrect T-SQL statements.

Object Scripting Fixed an issue where trying to script a table in a SQL DW database with both "Clustered Columnstore Indexes" and "Clustered Indexes" was generating incorrect T-SQL (duplicate statements).

Object Scripting Fixed Partitioned table scripting with no range values (SQL DW databases).

Object Scripting Fixed an issue where the user would be unable to script an audit/audit specification SERVER_PERMISSION_CHANGE_GROUP.

Object Scripting Fix and issue where the user is unable to script statistics from SQL DW. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897296.

Object Scripting Fixed an issue where the "Generate script wizard" shows incorrect table having scripting error when "Continue scripting on Error" is set to false.

Object Scripting Improved script generation on SQL Server 2019.

Profiler Added "Aggregate Table Rewrite Query" event to Profiler events.

Query Data Store Fixed an issue where a "DocumentFrame (SQLEditors)" exception could be thrown.

Query Data Store Fixed an issue when trying to set a custom time interval in the build-in Query Store reports the user wasn't able to select AM or PM on the start/end interval.

Results Grid Fixed an issue that was causing the in High Contrast mode (selected line numbers not visible).

Results Grid Fixed an issue, which resulted in an "Index out of range" exception when clicking on the grid.

Results Grid Fixed an issue where the grid result background color was being ignored. For details, see https://feedback.azure.com/forums/908035/suggestions/32895916.

ShowPlan New memory grant operator properties display incorrectly when there is more than one thread.

ShowPlan Add the following 4 attributes in RunTimeCountersPerThread of actual execution xml plan: HpcRowCount (Number of rows processed by a hpc device), HpcKernelElapsedUs (elapsed time wait for kernel execution in use), HpcHostToDeviceBytes (bytes transferred from host to device), and HpcDeviceToHostBytes (bytes transferred from device to host).

ShowPlan Fixed an issue where the similar plan nodes are highlighted in the wrong position.

SMO Fixed an issue where SMO/ServerConnection didn't SqlCredential-based connections correctly. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/33698941.

SMO Fixed an issue where an application written using SMO would encounter an error if it tried to enumerate databases from the same server on multiple threads even though it uses separate SqlConnection instances on each thread.

SMO Fixed performance regression in Transfer from External Tables.

SMO Fixed issue in ServerConnection thread-safety, which was causing SMO to leak SqlConnection instances when targeting Azure.

SMO Fixed an issue, which was causing a StringBuilder.FormatError when trying to restore a database, which had curly braces in its name.

SMO Fixed an issue where Azure databases in SMO were defaulting to Case-Insensitive collation for all string comparisons instead of using the specified collation for the database.

SSMS Editor Fixed an issue where "SQL System Table" where restoring the default colors was chancing the color to lime green, rather than the default green, making it hard to read on a white background. For details, see Restoring wrong default color for SQL System Table. The issue still persists on non-English versions of SSMS.

SSMS Editor Fixed issue where intellisense wasn't working when connected to Azure SQLDW using AAD authentication.

SSMS Editor Fixed intellisense in Azure when user lacks access to master database.

SSMS Editor Fixed code snippets to create "temporal tables", which were broken when the collation of the target database was case-sensitive.

SSMS Editor New TRANSLATE function now recognized by intellisense. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898430.

SSMS Editor Improved intellisense on FORMAT built-in function. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898676.

SSMS Editor LAG and LEAD are now recognized as built-in functions. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898757.

SSMS Editor Fixed an issue where intellisense was giving a warning when using "ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)".

SSMS Editor Fixed an issue where several system views and table values functions weren't properly colorized.

SSMS Editor Fixed an issue where clicking on editor tabs could cause the tab to be closed instead of getting the focus. For details, see https://feedback.azure.com/forums/908035/suggestions/37291114.

SSMS Options Fixed an issue where Tools > Options > SQL Server Object Explorer > Commands page wasn't resizing properly.

SSMS Options SSMS now by default disables automatic download of DTD in XMLA editor -- XMLA script editor (which uses the xml language service) by default now prevents automatically downloading the DTD for potentially malicious xmla files. This is controlled by turning off the "Automatically download DTDs and Schemas" setting in Tools > Options > Environment > Text Editor > XML > Miscellaneous.

SSMS Options Restored CTRL+D to be the shortcut as it used to be in older version of SSMS. For details, see https://feedback.azure.com/forums/908035/suggestions/35544754.

Table Designer Fixed a crash in "Edit 200 rows".

Table Designer Fixed an issue where the designer was allowing to add a table when connected to an Azure SQL Database.

Vulnerability Assessment Fixed an issue where the scan results aren't being loaded properly.

XEvent Added two columns "action_name" and "class_type_desc" that show action ID and class type fields as readable strings.

XEvent Removed the event XEvent Viewer cap of 1,000,000 events.

XEvent Profiler Fixed an issue where XEvent Profiler failed to launch when connected to a 96-core SQL Server.