Release notes for SQL Server Management Studio (SSMS)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics

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

Current SSMS release

18.7

download Download SSMS 18.7

  • Release number: 18.7
  • Build number: 15.0.18357.0
  • Release date: October 20, 2020

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

SSMS 18.7 is the latest general availability (GA) release of SSMS. If you need a previous version of SSMS, see previous SSMS releases.

What's new in 18.7

Important

Beginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.

To learn more about Azure Data Studio, check out What is Azure Data Studio or the FAQ.

New item Details
Azure Data Studio installation integration Installation of SSMS also installs Azure Data Studio.
Always Encrypted To recognize the new HSM endpoints, you need to upgrade SSMS. This is done by consuming the new AKV Provider NugetPackage.
Import Flat File Made an improvement to better predict data types by learning on 300 lines by default.
Import Flat File Prevent columns from being declared as TinyInt that should be SmallInt.
Import Flat File Made an improvement where DW tables are properly cleaned, if there is a failure in data import.
Resource Governor Added support for decimal values.
ShowPlan Added PREDICT operator.
XEvent UI Added capability to script out Extended Events using the wait_type name. Users are requesting to use the value of map_value column instead of map_key in wait_type filter predicate as the key value is subjected to change during version upgrade. Fix: Added a checkbox and given the option to users, to choose either map_value or map_key for the wait_type filter predicate value.

Bug fixes in 18.7

New Item Details
Accessibility Fixed tab ordering of buttons in the "The following settings are not supported by the database" window that pops up when querying against DW.
Accessibility Import and Export Wizard: the page layout is incorrect in high dpi mode.
Activity Monitor Fixed an issue where Activity Monitor was pausing when opening the "Processes" tab. See SQL Server User Feedback.
Always On Availability Group Fixed an issue where Read Scale Availability Group Failover was not working.
Analysis Services Updated PowerQuery components to 2.84.982 for AS Tabular models scenarios.
Analysis Services Fixed an issue that may have resulted in an error when trying to connect to SSAS via msmdpump.dll. See SQL Server User Feedback.
Backup/Restore Fixed an issue where selecting "View Connection Properties" yielded a SMO error on HostDistribution prop being missing for SQL 2016 and earlier.
Database Designer Fixed an issue, which was causing SSMS to crash when handling decimal numbers.
Database Diagrams Fixed an issue that could cause SSMS to crash or hang when using Database Diagrams where "Add Table" dialog was not properly displayed.
Database Mirroring Fixed an issue that was causing mirror configuration to fail. See SQL Server User Feedback.
General SSMS Fixed an issue where trying to connect to an Azure SQL DB, which could take several seconds (SQL login in a user database).
General SSMS Fixed an issue where SSMS was not handling/displaying deadlock captured (.xdl files).
General SSMS Fixed an issue where trying to open error log settings for SQL Server 2008 R2 and below failed with ErrorLogSizeKb property not found.
General SSMS General fixes and improvements around Azure Synapse Analytics SQL on-demand support.
Import Flat File Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
Import/Export Data-Tier Application Fixed the default service tier to be Standard S0 when importing a bacpac (same as Azure portal and SqlPackage.exe behavior).
Import Flat File Fixed an issue where the wizard was not detecting that the file could be in use by another application and instead was throwing an error. See SQL Server User Feedback.
Integration Services Fixed an issue that Azure Subscription ComboBox items are duplicate in IR Creation Wizard and Job Migration Wizard when different subscriptions have the same name.
Integration Services Fixed an issue that sometimes Connect button cannot be enabled in IR Creation Wizard.
Integration Services Fixed an issue that items of "Use Environment variable" ComboBox in "Set Parameter Value" dialog are not in order.
Intellisense Fixed a crash in SSMS that could happen when executing a query.
Intellisense Fixed an issue where intellisense doesn't work when the user is connected to an Availability Group configured for Read-Only Routing.
Linked Servers Fixed an issue where a user with CONTROL SERVER permission (but not in sysadmin role) was not able to add a linked server.
Log Viewer Fixed an issue where a user with VIEW SERVER STATE permissions was not able to view the SQL Server Error Logs. See SQL Server User Feedback.
Object Explorer Fixed an issue where selecting the Start PowerShell menu on some Object Explorer nodes (like "Policy Management", "Extended Events") would cause PowerShell not to start correctly.
Registered Servers Fixed an issue where SSMS crashed when trying to register a Central Management Server.
Registered Servers Fixed the issue where menu items to launch Azure Data Studio from Registered Servers was missing.
Reports Fixed an issue where on the Performance Dashboard you try to navigate to sublinks (such as Expensive Queries) and it doesn't work. This issue was common on most non-English versions of SSMS. See SQL Server User Feedback.
ShowPlan Fixed and issue that was causing SSMS to crash when using Find Node to search for text. See SQL Server User Feedback.
ShowPlan Add KB suffix on the Memory Grant tooltip row
Vulnerability Assessment Fixed an issue that was causing SSMS to throw an error when trying to set baselines in Vulnerability Assessment. See SQL Server User Feedback.
XEvent UI Fixed the issue where hitting F1 was not landing on the correct page on DOCS.
XEvent UI Fixed log in XEvent Viewer where the tooltip was not displaying correctly text containing text encoded using surrogate pairs.

Known issues (18.7)

New Item Details Workaround
Analysis Services Error when connecting to SSAS via msmdpump.dll. See SQL Server user feedback. N/A
Analysis Services In rare cases when using upgrade setup, there may be an "Object not set to instance of an object" error when attempting to open the DAX editor after upgrading SSMS. To solve this issue, uninstall and then reinstall SSMS.
General SSMS New Server Audit Specification dialog may cause SSMS to crash with an access violation error. N/A
General SSMS SSMS Extensions using SMO should be recompiled targeting the new SSMS-specific SMO v161 package. A preview version is available at https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects.SSMS/
Extensions compiled against previous 160 versions of Microsoft.SqlServer.SqlManagementObjects package will still function.
N/A
Integration Services When importing or exporting packages in Integration Services or exporting packages in Azure-SSIS Integration Runtime, scripts are lost for packages containing script tasks/components. Workaround: Remove folder "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild". N/A
Integration Services Remote connections to Integration services may fail with "The specified service does not exist as an installed service." on newer Operating system. Workaround: Identify the Integration services-related registry location under Computer\HKEY_CLASSES_ROOT\AppID & Computer\HKEY_CLASSES_ROOT\ WOW6432Node\AppID and within these hives, rename the registry key named 'LocalService' to 'LocalService_A' for the specific version of Integration services that we are trying to connect N/A
Object Explorer Releases of SSMS before 18.7 have a breaking change in object explorer due to the engine's changes related to Azure Synapse Analytics SQL on-demand. To continue utilizing object explorer in SSMS with Azure Synapse Analytics SQL on-demand, you need SSMS 18.7 or later.
Query Store The object explorer node for Query Store throws an error on right-click. Access items directly by expanding the node and right-clicking individual child options.

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

Previous SSMS releases

Note

In December 2021, releases of SSMS prior to 18.6 will no longer authenticate through Azure Active Directory with MFA.

To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later.

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

SSMS version Build number Release date
18.6 15.0.18338.0 July 22, 2020
18.5.1 15.0.18333.0 June 09, 2020
18.5 15.0.18330.0 April 07, 2020
18.4 15.0.18206.0 November 04, 2019
18.3.1 15.0.18183.0 October 02, 2019
18.2 15.0.18142.0 July 25, 2019
18.1 15.0.18131.0 June 11, 2019
18.0 15.0.18118.0 April 24, 2019
17.9.1 14.0.17289.0 November 21, 2018
16.5.3 13.0.16106.4 January 30, 2017

18.6

download Download SSMS 18.6

  • Release number: 18.6
  • Build number: 15.0.18338.0
  • Release date: July 22, 2020

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

What's new in 18.6

New item Details
Analysis Services Updated to latest release of AS client libraries.
Auditing Added support for SENSITIVE_BATCH_COMPLETED_GROUP action ID (string instead of a number).
Auditing Added the following fields to the audit viewer: affected_rows, response_rows, connection_id, duration_milliseconds, and data_sensitivity_information.
Data Classification Update SSMS to support the import/export of policy exported via PowerShell cmdlets.
Import Flat File Added support for Fixed Width files and file type detection for .csv/.tsv files to ensure they are parsed as csv/tsv files respectively.
Integration Services Added support for Azure SQL Managed Instance agent jobs to execute an SSIS package from package store in Azure-SSIS IR.
SMO / Scripting Added support to script Dynamic Data Masking on Azure Synapse Analytics (formerly SQL Azure DW).
SMO / Scripting Added support to script Security Policy on Azure Synapse Analytics (formerly SQL DW).

Bug fixes in 18.6

New Item Details
Accessibility Adjusted border colors for accessibility on the Database general properties page (the border around the grid and name box is darker to set the contrast to > 3:1).
Accessibility Added handling for query execution to update the narrator (requires NetFx4.8+ installed on the machine).
Always Encrypted Fixed issue where New Column Encryption Key dialog says the CEK is not enclave-enabled even if the CMK is enclave-enabled.
Analysis Services Fixed an issue viewing Analysis Services partitions that may have caused an unhandled exception.
Database Diagrams Fixed long outstanding issue with Database Diagrams, causing both the corruption of existing diagrams and SSMS to crash. If you created or saved a diagram using SSMS 18.0 through 18.5.1, and that diagram includes a Text Annotation, you won't be able to open that diagram in any version of SSMS. With this fix, SSMS 18.6 can open and save a diagram created by SSMS 17.9.1 and prior. SSMS 17.9.1 and previous releases can also open the diagram after being saved by SSMS 18.6. See SQL Server user feedback.
Data Classification Fixed an issue where the column name does not show in the recommendation panel of the data classification pane.
General SSMS Fixed an issue where database properties Size and Space Available have incorrect values for SQL Azure DB (Hyperscale service tier).
General SSMS Fixed an issue where database properties "Size" display the Max Size instead of the actual size of the database for SQL Azure DBs (note: for DW, it still shows the Max Size).
General SSMS Addressed three common sources of hangs in SSMS.
General SSMS Fixed a few issues related to SSMS Connection Dialog forgetting entries (server/user/passwords). See SQL Server user feedback and SQL Server user feedback.
General SSMS Fixed an issue on the Statistic Properties dialog where selecting the Update statistics for these columns checkbox and selecting OK yields no effect. Statistics are not updated, and trying to script the action yields a There is no action to be scripted message). See SQL Server user feedback.
General SSMS Addressed issues related to CVE-2020-1455.
Import/Export Data-Tier Application Fixed an issue where the SSMS was throwing an error when importing a bacpac file. See SQL Server user feedback.
Integration Services Fixed a bug that customers can't edit a SQL agent job step when using SSMS versions 18.4 or earlier to execute SSIS packages in Azure SQL Managed Instance.
Integration Services Fixed a bug where the Use 32-bit runtime option is missing in the Execution options tab to execute an SSIS package in a SQL agent job step for an on-premises SQL Server.
Intellisense / Editor Fixed an issue where an error dialog may pop up when doing File -> New -> Database Engine Query.
Object Explorer Fixed an issue where Properties window was not available for Azure SQL Database when right-clicking on a Table or Index node in Object Explorer.
Object Explorer Addressed an issue where SSMS can't expand databases node for master in Azure if there's a control plane outage affecting sys.database_service_objectives.
Reports Fixed several standard reports that were broken on Linux
Example: Memory Consumption report was failing with an error similar to "/var/opt/mssql/log/log_116.trc\log.trc' is invalid…").
SMO / Scripting Updated the logic to create new databases in Azure SQL Database to use Gen5_2 as the default SLO.
Xevent UI Fixed long outstanding issue (introduced in SSMS 18.0) where "Save to XEL file…" was throwing an error. See SQL Server user feedback.

Known issues (18.6)

New Item Details Workaround
Analysis Services Error when connecting to SSAS via msmdpump.dll. See SQL Server user feedback. N/A
General SSMS New Server Audit Specification dialog may cause SSMS to crash with an access violation error. N/A
General SSMS SSMS Extensions using SMO should be recompiled targeting the new SSMS-specific SMO v161 package. A preview version is available at https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects.SSMS/
Extensions compiled against previous 160 versions of Microsoft.SqlServer.SqlManagementObjects package will still function.
N/A
Integration Services When importing or exporting packages in Integration Services or exporting packages in Azure-SSIS Integration Runtime, scripts are lost for packages containing script tasks/components. Workaround: Remove folder "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild". N/A
Integration Services Remote connections to Integration services may fail with "The specified service does not exist as an installed service." on newer Operating system. Workaround: Identify the Integration services related registry location under Computer\HKEY_CLASSES_ROOT\AppID & Computer\HKEY_CLASSES_ROOT\ WOW6432Node\AppID and within these hives, rename the registry key named 'LocalService' to 'LocalService_A' for the specific version of Integration services that we are trying to connect N/A

18.5.1

download Download SSMS 18.5.1

  • Release number: 18.5.1
  • Build number: 15.0.18333.0
  • Release date: June 09, 2020

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

Bug fixes in 18.5.1

New Item Details
Analysis Services Improved performance when expanding the list of databases while connected to AS Azure or Power BI servers.
Analysis Services Fixed an issue where an error would occur trying to open the Synchronize Database Wizard of an Analysis Services server.
Analysis Services Fixed an issue preventing users from querying SSAS 2017 and earlier versions with cell data permissions.
General SSMS Table Designer - Fixed beep when trying to TAB in a Table Designer grid

Known issues (18.5.1)

New Item Details Workaround
General SSMS There is a known bug with Diagram Design that causes your existing diagrams to get corrupted. For example, you create a Diagram Design with SSMS 17.9.1, then update/save it with SSMS 18.x, and then later try to open it with 17.9.1. See SQL Server user feedback for more details. N/A
General SSMS New Server Audit Specification dialog may cause SSMS to crash with an access violation error. N/A
SMO/Scripting SSMS Extensions using SMO need to be recompiled targeting the new SMO v160. N/A
Integration Services When importing or exporting packages in Integration Services or exporting packages in Azure-SSIS Integration Runtime, scripts are lost for packages containing script tasks/components. Workaround: Remove folder "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild".

18.5

download Download SSMS 18.5

  • Release number: 18.5
  • Build number: 15.0.18330.0
  • Release date: April 07, 2020

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

What's new in 18.5

New item Details
Analysis Services Added support for Power BI endpoint in Analysis Services - matching functionality of Azure Analysis Services.
Analysis Services Profiler: added support for Analysis Services Trace Definition 15.1.
Data Classification Added a button to the VA scan result view, in order to remediate data classification rule by going to the data classification pane.
Data Classification Added support for sensitivity rank in Data Classification.
Hyperscale Added support for Import Data-Tier Application (.bacpac) to SQL Azure HyperScale.
Integration Services Support executing SSIS Package from file system in MI Agent Job.
Integration Services Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.
Integration Services Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.
Integration Services Support migrating on-premises SSIS agent jobs to ADF pipelines and triggers.
Integration Services Made an improvement for the user experience of exporting SSIS projects from SSIS DB. Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version-independent Export won't load and upgrade packages in the SSIS project. Instead, it keeps packages in the projects as they are in SSIS DB except changing protection level to EncryptSensitiveWithUserKey.
SMO/Scripting Added new DwMaterializedViewDistribution property to View object.
SMO/Scripting Removed support for Feature Restriction (this preview feature has been removed from SQL Azure and SQL on-prem).
SMO/Scripting Added Notebook as a destination for Generate Scripts wizard.
SMO/Scripting Added support for SQL On Demand.
SMO/Scripting SQL Assessment API - Platform, Name, and engineEdition fields can now contain usual comma-separated lists (platform: [Windows, Linux]), not only regular expressions (platform: /Windows|Linux/)
SMO/Scripting SQL Assessment API - Added 13 assessment rules. For more details, go to GitHub).

Bug fixes in 18.5

New Item Details
Accessibility SSIS ADF / New Schedule: fixed an issue where the focus order is not logical in the scan mode of narrator under New Schedule wizard.
Accessibility Stretch database wizard: fixed an issue where the screen reader does not inform about the name of the query table when providing information about the table.
Analysis Services Fix cached connection when scripting in AS with Azure AD connection.
Always On Fixed an issue where the first database added to Always On AG does not join correctly.
Always On Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.
Auditing Fixed an issue where the Audit logs merges window crashes when there's a folder with an empty name in the root folder of the storage account.
Auditing Fixed an issue where the Audit logs merge window doesn't show all servers when there are too many items in the root of the container.
Data Classification Fixed an issue where the Data Classification wizard won't open for databases with large number of tables.
Data Classification We are now enforcing different GUIDs for every label/infoType and GUID's structure in the validation process.
Data Classification Remove classification process in SqlServer2019.
Data Classification Correcting the previous validation tests (adding rank, removing the illegal property InformationTypes) and adding new ones for the first two points.
Data Classification The button just above the classified columns table now minimizes the recommendations panel, as it says.
General SSMS Updating the version of MSODBC and MSOLEDB drivers.
General SSMS Addressed at least two common sources hangs and crashes in SSMS.
General SSMS Addressed one more case where Restore dialog hangs when selecting the Browse button.
General SSMS Fixed New Database GUI for SQL On Demand.
General SSMS Fixed New External Table... and New External Data Source... templates for SQL On Demand.
General SSMS Fixed database properties, connection properties, hiding reports and rename for SQL On Demand.
General SSMS Always Encrypted: Fixed an issue where the key name dropdown becomes read-only on selecting new enclave enabled key.
General SSMS Cleaned up the Database Property Options grid, which was showing two Miscellaneous Categories.
General SSMS Fixed an issue where the scroll bar started from middle in "Database Properties Options" grid.
General SSMS Fixed an issue that was causing SSMS to crash when opening .sql file while connected to Analysis Services server.
General SSMS Connection Dialog: fixed an issue where unchecking the "Remember Password" does not work.
General SSMS Fixed an issue where credentials associated to Server/Users are always remembered. See SQL Server user feedback.
General SSMS Fixed issue where occasionally Editor windows was not properly refreshed. This is achieved by disabling the hardware acceleration in Tools > Options > Environment. See SQL Server user feedback.
General SSMS Fixed an issue where Azure Active Directory authentication was not working through a proxy.
High DPI/Scaling Fixed an issue where the controls on the Index properties could be incorrectly rendered (buttons overlapping grid). See SQL Server user feedback.
High DPI/Scaling Fixed multiple issues in Database Properties dialog, which might show clipped controls on 4K monitors.
High DPI/Scaling Fixed Publication and Subscription Wizards on 4k displays.
High DPI/Scaling Minor fix on New Audit Server Specification page.
High DPI/Scaling Fixed 4k display issue on High Availability Wizard.
High DPI/Scaling Fixed an issue where the user was not able to add a target in an Xevent New Session window + Set Session Event Filters in Xevent Session Wizard when display scaling at 125%.
High DPI/Scaling Fixing an issue where controls on the Backup Database to URL UI render out of sight under scaling above 100%.
Import flat file Updated Flat File Import Wizard to allow check all for the allow null column. See SQL Server user feedback.
Object Explorer Fixed an issue where Object Explorer could display incorrect information when connection strings are used to connect in Connection Dialog.
Object Explorer Fixed an issue where OE was slow in expanding tables for databases with several thousands tables (20k+).
Query Store UI Fixed TRC report calculate execution count (for wait time metric) as the sum of execution counts for each individual wait category, which is incorrect. But for a single execution of query it will be registered for each of the wait category the query waited for. So, if TRC just sums it across the wait category it will bloat the execution count. Actually it should be the Max across the wait_category.
Query Store UI Fixed TRC detailed view returns incorrect data when result set is filtered on top x. This happens because the query uses multiple common table expressions, which are then joined together to create the final result set. If top x is pushed into CTE, it sometimes can filters out the required rows. This can sometimes make the result set non-deterministic. The fix is to not push top x clause to CTEs.
Query Store UI Fixed Plan summary in both - grid or chart view needs last query execution wait time. Absence of this column is breaking the query. This change set will add this column to the wait stats CTE.
ShowPlan Improved how SSMS displays estimated row counts for operators with multiple executions: (1) Modified Estimated Number of Rows in SSMS to "Estimated Number of Rows Per Execution"; (2) Added a new property Estimated Number of Rows for All Executions; (3) Modify the property Actual Number of Rows to Actual Number of Rows for All Executions.
SQL Agent Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing. SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime). Also SSMS is not disabling the "View" button when the user does not have access to the file (as far as SQL permissions go). See SQL Server user feedback.
SQL Agent Fixed the tab ordering on the Job Step page.
SQL Agent Reversed the position of the "Next" and "Previous" buttons on the Job Step page to put them in a logical order.
SQL Agent Adjusted the Job Schedule window to not clip the UI.
SMO/Scripting Fixed database scripting for SQL On Demand.
SMO/Scripting Removing explicit sqlvariant cast (illegal T-SQL syntax for SqlOnDemand) which fixes scripting for SqlOnDemand.
SMO/Scripting Fixed an issue where FILLFACTOR on indexes for SQL Azure was skipped.
SMO/Scripting Fixed an issue related to scripting External objects.
SMO/Scripting Fixed an issue where Generate Scripts was not allowing choosing the scripting option for Extended Properties against SQL Database. Also, fixed the scripting of such extended properties.
SMO/Scripting SQL Assessment API - Wrong help link in XTPHashAvgChainBuckets rule.
XEvent UI Fixed an issue here items in the grid where being selected on hovering. See SQL Server user feedback and SQL Server user feedback.

Known issues (18.5)

New Item Details Workaround
  • Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). See SQL Server user feedback 37992649 for more details.

  • When importing or exporting packages in Integration Services or exporting packages in Azure-SSIS Integration Runtime, scripts are lost for packages containing script tasks/components. A workaround is to remove the folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild.

  • New Server Audit Specification dialog may cause SSMS to crash with an access violation error.

  • SSMS Extensions using SMO would need to be recompiled targeting the new SMO v160 (package will be available on nuget.org right after SSMS 18.5 is released).

  • Error when connecting to SSAS via msmdpump.dll in SSMS.

18.4

download Download SSMS 18.4

  • Release number: 18.4
  • Build number: 15.0.18206.0
  • Release date: November 04, 2019

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

New item Details
Data Classification Added support for custom information protection policy for data classification.
Query Store Added the Max Plan per query value in the dialog properties.
Query Store Added support for the new Custom Capture Policies.
Query Store Added Wait Statistics Capture Mode to the Query Store Database Properties options.
SMO/Scripting Support Script of materialized view in SQL DW.
SMO/Scripting Added support for SQL On Demand.
SMO/Scripting SQL Assessment API - Added 50 assessment rules (see details on GitHub).
SMO/Scripting SQL Assessment API - Added base math expressions and comparisons to rules conditions.
SMO/Scripting SQL Assessment API - Added support for RegisteredServer object.
SMO/Scripting SQL Assessment API - Updated way how rules are stored in the JSON format and also updated the mechanism of applying overrides/customizations.
SMO/Scripting SQL Assessment API - Updated rules to support SQL on Linux.
SMO/Scripting SQL Assessment API - Updated the ruleset JSON format and added SCHEMA version.
SMO/Scripting SQL Assessment API - Updated cmdlets output to improve readability of recommendations.
XEvent Profiler Added error_reported event to XEvent Profiler sessions.

Bug fixes in 18.4

New Item Details
Analysis Services Fixed an issue where the DAX Script editor for multi-dimensional databases didn't show tables in the IntelliSense.
Analysis Services Use DAX Parser to convert to an Engine string. This is for international separators, decimal, and whitespace.
Always Encrypted Fixed an issue where the claim validation wasn't case insensitive.
Always Encrypted Fixed an issue where error/warning reporting wasn't properly working.
Copy Database Wizard Fixed assorted truncation and layout issues in the rendering of this dialog.
General SSMS Fixed a long outstanding issue where SSMS wasn't honoring the connection info passed at the command line when SQL files were also specified.
General SSMS Fixed a crash in SSMS while trying to display Securables on "Replication Filter" objects.
General SSMS Mitigated the removal of the -P command-line option by having SSMS look at its cache of credentials: if the required credential were found, the connection would be established using it.
Import flat file Fixed an issue where Import Flat File functionality not handling text qualifiers correctly.
Object Explorer Fixed an issue where dropping an Azure SQL Database in Object Explorer was showing an incorrect message.
Query Results Fixing an issue introduced in SSMS 18.3.1, where grids are drawn slightly too narrow and show ... at the end of the longest string in every column.
Replication Tools Fixed an issue that was causing the application to throw an error ("couldn't load file or assembly…") when trying to edit SQL Agent jobs.
SMO/Scripting Fixed an issue when Script Table As… for SQL DW whose collation is Japanese_BIN2 wasn't working.
SMO/Scripting Fixed an issue where ScriptAlter() ended up executing the statements on the server.
SQL Agent Fixed an issue where the agent operator UI would not update the operator name when it was changed in the UI, nor is it scripted. See SQL Server user feedback for more details.

Known issues (18.4)

  • Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). See SQL Server user feedback for more details.

  • There are redraw issues when switching between multiple query windows. See SQL Server user feedback for more details. A workaround for this issue is to disable hardware acceleration under Tools > Options.

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

18.3.1

download Download SSMS 18.3.1

  • Release number: 18.3.1
  • Build number: 15.0.18183.0
  • Release date: October 02, 2019

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

What's new in 18.3.1

New item Details
Data Classification Add Data Classification information to column properties UI (Information Type, Information Type ID, Sensitivity Label, and Sensitivity Label ID aren't exposed in the SSMS UI).
Intellisense/Editor Updated support for features recently added to SQL Server 2019 (for example, ALTER SERVER CONFIGURATION).
Integration Services Add a new selection menu item Tools > Migrate to Azure > Configure Azure-enabled DTExec that invokes SSIS package executions on Azure-SSIS Integration Runtime as Execute SSIS Package activities in ADF pipelines.
SMO/Scripting Added support for Support scripting of Azure SQL DW unique constraint.
SMO/Scripting Data Classification
- Added support for SQL version 10 (SQL 2008) and higher.
- Added new sensitivity attribute 'rank' for SQL version 15 (SQL 2019) and higher and Azure SQL Database.
SMO/Scripting SQL Assessment API - Added versioning to ruleset format.
SMO/Scripting SQL Assessment API - Added new checks.
SMO/Scripting SQL Assessment API - Added support for Azure SQL Managed Instance.
SMO/Scripting SQL Assessment API - Updated default view of cmdlets to display results as a table.

Bug fixes in 18.3.1

New Item Details
Analysis Services Fix scaling issue in MDX Query Editor.
Analysis Services Fixed an issue in XEvent UI that prevents the users from being able to create a new session.
Database Deployment to SQL Azure Fixed an issue (in DacFx) which was causing this feature not to work.
General SSMS Fixed an issue, which was causing SSMS to crash when using the sorting feature in the XEvent viewer.
General SSMS Fixed long outstanding issues where SSMS Restore database may stop responding indefinitely.
See SQL Server user feedback items for more details:
Restore Database - Select Backup Devices Slow to Load.
SSMS 2016 very slow in the database restore dialogs.
Restoring database is slow.
Restore Database from Device HANGS on clicking "...".
General SSMS Fixed an issue where the default language for all logins was shown as Arabic.
See SQL Server user feedback item for more details: SSMS 18.2 default language display bug.
General SSMS Fixed the hard to see the dialog for Query Options (when the user right-clicks on the T-SQL editor window) by making it resizable.
General SSMS The Completion time message visible in the Result Grid/File (introduced in SSMS 18.2) is now configurable under Tools > Options > Query Execution > SQL Server > Advanced > Show completion time.
General SSMS In the connection dialog, replaced Active Directory - Password and Active Directory - Integrated with Azure Active Directory - Password and Azure Active Directory - Integrated, respectively.
General SSMS Fixed an issue that prevents users from being able to use SSMS to configure auditing on SQL Azure managed Instances when located in a TZ with negative UTC offset.
General SSMS Fixing an issue in XEvent UI where hovering over the grid was causing rows to be selected.
See SQL Server user feedback item for more details: SSMS Extended Events UI Selects Actions on Hover.
Import flat file Fixed the issue where Import Flat File wasn't importing all data by letting the user choose between a simple or rich data type detection.
See SQL Server user feedback item for more details: SSMS Import Flat File fails to import all data.
Integration Services Add new operation type StartNonCatalogExecution for SSIS Operation report.
Integration Services Fixed an issue in the Azure Data Factory pipelines generated by Azure-enabled DTExec utility to use the correct parameter type. (explicit for 18.3.1)
SMO/Scripting Fixed an issue, which was causing SMO to throw errors when fetching properties when SMO.Server.SetDefaultInitFields(true) was being used.
Query Store UI Fixed an issue where the Y-axis didn't scale when Execution Count Metric was selected in Tracked Query View.
Vulnerability Assessment Disabled clearing and approving baseline for Azure SQL Database.

Known issues (18.3.1)

  • Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). See SQL Server user feedback for more details.

  • There are redraw issues when switching between multiple query windows. See SQL Server user feedback for more details. A workaround for this issue is to disable hardware acceleration under Tools > Options.

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

18.2

download Download SSMS 18.2

  • Release number: 18.2
  • Build number: 15.0.18142.0
  • Release date: July 25, 2019

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

What's new in 18.2

New Item Details
Integration Services (SSIS) Perf optimization for SSIS package scheduler in Azure.
Intellisense/Editor Added support for Data Classification.
OPTIMIZE_FOR_SEQUENTIAL_KEY Added Intellisense support.
OPTIMIZE_FOR_SEQUENTIAL_KEY Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date/time column. See CREATE INDEX for more details.
Query Execution or Results Added a Completion time in the messages to track when a given query completed its execution.
Query Execution or Results Allow more data to be displayed (Result to Text) and stored in cells (Result to Grid). SSMS now allows up to 2M characters for both (up from 256 K and 64 K, respectively). This also addressed the issue of users not able to grab more than 43680 chars from the cells of the grid.
ShowPlan Added a new attribute in QueryPlan when inline scalar UDF feature is enabled (ContainsInlineScalarTsqludfs).
SMO Added support for SQL Assessment API. For more information, see SQL Assessment API.

Bug fixes in 18.2

New Item Details
Accessibility Updated the XEvent UI (the grid) to be sortable by pressing F3.
Always On Fixed an issue where SSMS was throwing an error when trying to delete an Availability Group (AG)
Always On Fixed an issue where SSMS was presenting the wrong failover wizard when replicas are configured as Synchronous when using read scale AGs (cluster type=NONE). Now, SSMS presents the wizard for Force_Failover_Allow_Data_Loss option, which is the only one allowed for cluster-type NONE Availability
Always On Fixed an issue where the wizard was restricting the number of allowed synchronizations to three
Data Classification Fixed an issue where SSMS was throwing an Index (zero-based) must be greater than or equal to zero error when trying to view data classification reports on databases with CompatLevel less than 150.
General SSMS Fixed an issue where the user was unable to horizontal scroll Results pane via mouse wheel. See SQL Server user feedback for more details.
General SSMS Updated Activity Monitor to ignore benign wait types SQLTRACE_WAIT_ENTRIES
General SSMS Fixed an issue where some color options (Text Editor > Editor Tab and Status Bar) weren't persisted. See SQL Server user feedback
General SSMS In the connection dialog, replaced Azure Active Directory - Universal with MFA support with Azure Active Directory - Universal with MFA (functionality is the same, but hopefully it's less confusing).
General SSMS Updated SSMS to use correct default values when creating an Azure SQL Database.
General SSMS Fixed an issue where the user wasn't able to Start PowerShell from a node in Register Servers when the server is a SQL Linux container.
Import Flat File Fixed an issue where Import Flat File wasn't working after upgrading from SSMS 18.0 to 18.1. See SQL Server user feedback
Import Flat File Fixed an issue where Import Flat File Wizard was reporting a duplicate or invalid column on a .csv file with headers with Unicode characters.
Object Explorer Fixed an issue where some menu items (for example, SQL server Import and Export Wizard) were missing or disabled when connected to SQL Express. See SQL Server user feedback for more details.
Object Explorer Fixed an issue, which was causing SSMS to crash when an object is dragged from Object Explorer to the editor. See SQL Server user feedback for more details.
Object Explorer Fixed an issue where renaming databases was causing incorrect database names to show up in Object Explorer. See SQL Server user feedback for more details.
Object Explorer Fixed a long outstanding issue where trying to expand the Tables node in Object Explorer for a database, which is set to use a collation that isn't supported by Windows anymore triggers an error (and the user can't expand their tables). An example of such collation would be Korean_Wansung_Unicode_CI_AS.
Register Servers Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the Registered Server uses either Active Directory - Integrated or Azure Active Directory - Universal with MFA didn't work because SSMS failed to connect.
Register Servers Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the registered server uses either Active Directory - Password or SQL Auth and the user chose not to remember the password would cause SSMS to crash.
Reports Fixed an issue in Disk Usage reports where the report was failing to when data files had a vast number of extents.
Replication Tools Fixed an issue where Replication Monitor wasn't working with publisher DB in AG and distributor in AG (this was previously fixed in SSMS 17.x
SQL Agent Fixed an issue that when Adding, inserting, editing, or removing job steps, was causing focus to be reset the first row instead of the active row. See SQL Server user feedback for more details.
SMO/Scripting Fixed an issue where CREATE OR ALTER wasn't scripting objects that had extended properties on them. See SQL Server user feedback for more details.
SMO/Scripting Fixed an issue where SSMS wasn't able to script CREATE EXTERNAL LIBRARY correctly. See SQL Server user feedback for more details.
SMO/Scripting Fixed an issue where trying to run the Generate Scripts against a database with a few thousand tables (was causing the progress dialog to appear to be stuck.
SMO/Scripting Fixed an issue where scripting of External Table on SQL 2019 didn't work.
SMO/Scripting Fixed an issue where scripting of External Data Source on SQL 2019 didn't work. See SQL Server user feedback for more details.
SMO/Scripting Fixed an issue where * extended properties* on columns weren't scripted when targeting Azure SQL Database. See stackoverflow for more details.
SMO/Scripting Last-page insert: SMO - Add property Index.IsOptimizedForSequentialKey
SSMS Setup Mitigated an issue where SSMS setup was incorrectly blocking the installation of SSMS reporting mismatching languages. This could have been an issue in some abnormal situations, like an aborted setup or an incorrect uninstall of a previous version of SSMS. See SQL Server user feedback for more details.
XEvent Profiler Fixed a crash when the viewer is being closed.

Known issues (18.2)

  • Database Diagram created from on an SSMS running on machine A cannot be modified from machine B (it would crash SSMS). See SQL Server user feedback for more details.

  • There are redraw issues when switching between multiple query windows. See SQL Server user feedback. A workaround for this issue is to disable hardware acceleration under Tools > Options.

  • There's a limitation on the size of the data you see from SSMS results shown in grid, text, or file.

  • There's an issue with receiving an error when deleting an Azure SQL Database in Object Explorer, but it actually succeeds.

  • The default language for SQL logins may display as Arabic in the Login Properties dialog, regardless of the actual default language set for the login. To view the actual default language for a given login, use T-SQL to select the login's default_language_name from master.sys.server_principles.

18.1

download Download SSMS 18.1

  • Release number: 18.1
  • Build number: 15.0.18131.0
  • Release date: June 11, 2019

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

What's new in 18.1

New item Details
Database diagrams Database diagrams were added back into SSMS.
SSBDIAGNOSE.EXE The SQL Server Diagnose (command-line tool) was added back into the SSMS package.
Integration Services (SSIS) Support for scheduling SSIS package, located in SSIS Catalog in Azure or File System, in Azure. There are three entries for launching the New Schedule dialog, New Schedule… menu item is shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and "Schedule SSIS in Azure" shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Managed Instance.

Bug fixes in 18.1

New Item Details
Accessibility Improved accessibility of the Agent Job UI. '
Accessibility Improved accessibility on the Stretch Monitor page by adding an accessible name for Auto Refresh button and also adding an intelligent Accessible Name that helps users know not only what button they're on but the impact of pressing it.
ADS integration Fixed a possible crash in SSMS when trying to use the ADS registered servers.
Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL Server 2019 CTP3.0)
Data classification Prevent adding sensitivity labels to columns in the history table, which isn't supported.
Data classification Addressed issue related to incorrect handling of compatibility level (server vs. database).
Database designer Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL2019 CTP3.0).
General SSMS Fixed an issue where scripting of pseudo columns in an index was incorrect.
General SSMS Fixed an issue in the Login properties page where clicking on the Add Credential button could throw a Null Reference Exception.
General SSMS Fixed money column size display in the index properties page.
General SSMS Fixed an issue where SSMS wasn't honoring the Intellisense settings from Tools/Options in the SQL editor window.
General SSMS Fixed an issue where SSMS wasn't honoring the Help settings (online vs. offline).
High DPI Fixed layout of controls in error dialogs for unsupported query options.
High DPI Fixed layout of controls in New Availability Group page, which is on some localized version of SSMS.
High DPI Fixed layout of New Job Schedule page. See SQL Server user feedback for more details.
Import flat file Fixed in an issue where rows could be silently lost during the import.
Intellisense/editor Reduced SMO-based query traffic to Azure SQL Database for IntelliSense.
Intellisense/editor Fixed grammatical error in the tooltip displayed when typing T-SQL to create a user. Also, fixed the error message to disambiguate between users and logins.
Log Viewer Fixed an issue where SSMS always opens the current server (or agent) log, even if double-clicking an older archive sign in the Object Explorer. See SQL Server user feedback for more details.
SSMS setup Fixed the issue that was causing SSMS setup to fail when the setup log path contained spaces. See SQL Server user feedback for more details.
SSMS setup Fixed an issue where SSMS was exiting immediately after showing the splash screen.
See these sites for more details: SQL Server user feedback, SSMS Refuses to Start, and Database Administrators.
Object explorer Lifted restriction on enabling start PowerShell when connected to SQL on Linux.
Object explorer Fixed an issue that was causing SSMS to crash when trying to expand the Polybase/Scale-out Group node (when connected to a compute node).
Object explorer Fixed an issue where the Disabled menu item was still enabled, even after disabling a given Index. See SQL Server user feedback for more details.
Reports Correcting report to display GrantedQueryMemory in KB (SQL Performance Dashboard report). See SQL Server user feedback for more details.
Reports Improved the tracing of the log block in Always-On scenarios.
ShowPlan Added new showplan element SpillOccurred to showplan schema.
ShowPlan Added remote reads (ActualPageServerReads, ActualPageServerReadAheads ActualLobPageServerReads, ActualLobPageServerReadAheads) to showplan schema.
SMO/scripting Avoid querying edge constraints during scripting for non-graph tables.
SMO/scripting Removed constraint on sensitivity classification when scripting columns with Data classification.
SMO/scripting Fixed an issue where "Generate Script" on a graph table fails when generating data. See SQL Server user feedback for more details.
SMO/scripting Fixed an issue where the EnumObjects() method wasn't fetching schema name for a Synonym.
SMO/scripting Fixed an issue in UIConnectionInfo.LoadFromStream() where the AdvancedOptions section wasn't read (when a password wasn't specified).
SQL Agent Fixed an issue that was causing SSMS to crash while working with a Job Properties window. See SQL Server user feedback for more details.
SQL Agent Fixed an issue where the "View" button on the Job-Step Properties wasn't always enabled, thus preventing viewing the output of a given job step.
XEvent UI Added "Package" column to XEvents list to disambiguate events with identical names.
XEvent UI Added missing "EXTERNAL LIBRARY" class type mapping to XEventUI.

Known issues (18.1)

  • Users may see an error when dragging a table object from the Object Explorer into the Query Editor. We are aware of the issue, and the fix is planned for the next release.

  • The Group connections and Single-server connections color options under the Options -> Text Editor -> Editor Tab and Status Bar -> Status Bar Layout and Colors do not persist after closing SSMS 18.1. After you reopen SSMS, the Status Bar Layout and Colors option revert to default (white).

  • There is a limitation on the size of the data you see from SSMS results shown in the grid, text, or file.

  • Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). See SQL Server user feedback for more details.

18.0

download Download SSMS 18.0

  • Release number: 18.0
  • Build number: 15.0.18118.0
  • Release date: April 24, 2019

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

What's new in 18.0

New item Details
Support for SQL Server 2019 SSMS 18.0 is the first release that is fully aware of SQL Server 2019 (compatLevel 150).
Support for SQL Server 2019 Support for "BATCH_STARTED_GROUP" and "BATCH_COMPLETED_GROUP" in SQL Server 2019 and SQL Managed Instance.
Support for SQL Server 2019 SMO: Added support for UDF Inlining.
Support for SQL Server 2019 GraphDB: Add a flag in showplan for Graph TC Sequence.
Support for SQL Server 2019 Always Encrypted: added support for AEv2 / Enclave.
Support for SQL Server 2019 Always Encrypted: connection dialog has a new tab "Always Encrypted" when the user clicks on the "Options" button to enable/configure Enclave support.
Smaller SSMS download size The current size is ~500 MB, approximately half of the SSMS 17.x bundle.
SSMS is based on the Visual Studio 2017 Isolated Shell The new shell (SSMS is based on Visual Studio 2017 15.9.11) unlocks all the accessibility fixes that went into both SSMS and Visual Studio, and includes the latest security fixes.
SSMS accessibility improvements Much work went in to address accessibility issues in all the tools (SSMS, DTA, and Profiler)
SSMS can now be installed in a custom folder This option is available from both the command line (useful for unattended installation) and the setup UI. From the command line, pass this extra argument to the SSMS-Setup-ENU.exe: SSMSInstallRoot=C:\MySSMS18 By default, the new install location for SSMS is: %ProgramFiles(x86)%\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exe. This does not mean that SSMS is multi-instance.
SSMS allows installing in a language other than the OS language The block on mixed languages setup has been lifted. You can, for example, install SSMS German on a French Windows. If the OS language does not match the SSMS language, the user needs to change the language under Tools > Options > International Settings, otherwise SSMS shows the English UI.
SSMS no longer shares components with the SQL Engine Much effort went in to avoid sharing components with SQL Engine, which often resulted in serviceability issues (one clobbering the files installed by the other).
SSMS requires NetFx 4.7.2 or greater We upgraded our minimum requirement from NetFx4.6.1 to NetFx4.7.2: this allows us to take advantage of the new functionality exposed by the new framework.
Ability to migrate SSMS settings When SSMS 18 is started for the first time, the user is prompted to migrate the 17.x settings. The user setting files are now stored as a plain XML file, thus improving portability and possibly allowing editing.
Support for High DPI High DPI is now enabled by default.
SSMS ships with the Microsoft OLE DB driver For details, see Download Microsoft OLE DB Driver for SQL Server.
SSMS isn't supported on Windows 8. Windows 10 and Windows Server 2016 require version 1607 (10.0.14393) or later Due to the new dependency on NetFx 4.7.2, SSMS 18.0 does not install on Windows 8 and older versions of Windows 10 and Windows Server 2016. SSMS setup blocks those systems. Windows 8.1 is still supported.
SSMS is no longer added to the PATH environment variable Path to SSMS.EXE (and tools in general) isn't added to the path anymore. Users can either manually add it, or if on a modern Windows computer, use on the Start menu.
Package IDs are no longer needed to develop SSMS Extensions In the past, SSMS was selectively loading only well-known packages, thus requiring developers to register their own package. This is no longer the case.
General SSMS Exposing AUTOGROW_ALL_FILES config option for Filegroups in SSMS.
General SSMS Removed risky 'lightweight pooling' and 'priority boost' options from SSMS GUI. For details, see Priority boost details – and why it's not recommended.
General SSMS New menu and key bindings to creates files: CTRL+ALT+N. CTRL+N continues to create a new query.
General SSMS New Firewall Rule dialog now allows the user to specify a rule name, instead of automatically generating one on behalf of the user.
General SSMS Improved IntelliSense in Editor especially for v140+ T-SQL.
General SSMS Added support in SSMS UI for UTF-8 on collation dialog.
General SSMS Switched to "Windows Credential Manager" for connection dialog MRU passwords. This addresses a long outstanding issue where persistence of passwords wasn't always reliable.
General SSMS Improved support for multi-monitor systems by making sure that more and more dialogs and windows pop up on the expected monitor.
General SSMS Exposed the 'backup checksum default' server configuration in the new Database Settings page of the Server Properties Dialog. For details, see https://feedback.azure.com/forums/08035-sql-server/suggestions/34634974.
General SSMS Exposed "maximum size for error log files" under "Configure SQL Server Error Logs". For details, see https://feedback.azure.com/forums/908035/suggestions/33624115.
General SSMS Added "Migrate to Azure" under Tools menu – We have integrated Database Migration Assistant and Azure Database Migration Service to provide quick and easy access to help accelerate your migrations to Azure.
General SSMS Added logic to prompt the user to commit open transactions when "Change connection" is used.
Azure Data Studio integration Added menu item to start/download Azure Data Studio.
Azure Data Studio integration Added "Start Azure Data Studio" menu item to Object Explorer.
Azure Data Studio integration When right-clicking on a database node in OE, the user is presented with context menus to either run a query or create a new notebook in Azure Data Studio.
Azure SQL support SLO/Edition/MaxSize database properties now accept custom names, making it easier to support future editions of Azure SQL Database.
Azure SQL support Added support for vCore SKUs (General Purpose and Business Critical): Gen4_24 and all the Gen5.
Azure SQL Managed Instance Added new "Azure AD logins" as a new login type in SMO and SSMS when connected to Azure SQL Managed Instance.
Always On Rehash RTO (estimated recovery time) and RPO (estimated data loss) in SSMS Always on Dashboard. See the updated documentation at https://docs.microsoft.com/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups.
Always Encrypted The Enable Always Encrypted checkbox in the new Always Encrypted tab in the Connect to Server dialog now provides an easy way to enable/disable Always Encrypted for a database connection.
Always Encrypted with secure enclaves Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019: A text field for specifying enclave attestation URL in the Connect to Server dialog (the new Always Encrypted tab). The new checkbox in the New Column Master Key dialog to control whether a new column master key allows enclave computations. Other Always Encrypted key management dialogs now expose the information on which column master keys allow enclave computations.
Audit Files Changed authentication method from Storage Account Key based to Azure AD-based authentication.
Data Classification Reorganized data classification task menu: added sub menu to the database tasks menu and added an option to open the report from the menu without opening the classify data window first.
Data Classification Added new feature 'Data classification' to SMO. Column object exposes new properties: SensitivityLabelName, SensitivityLabelId, SensitivityInformationTypeName, SensitivityInformationTypeId, and IsClassified (read-only). For more information, see ADD SENSITIVITY CLASSIFICATION (Transact-SQL)
Data Classification Added new "Classification Report" menu item to the "Data Classification" flyout.
Data Classification Updated recommendations.
Database Compatibility Level Upgrade Added a new option under Database name > Tasks > Database Upgrade. This starts the new Query Tuning Assistant (QTA) to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level. Upgrading to the desired database compatibility level. Collecting a second pass of performance data over the same workload. Detect workload regressions, and provide tested recommendations to improve workload performance. This is close to the database upgrade process documented in query store usage scenarios, except for the last step where QTA does not rely on a previously known good state to generate recommendations.
Data-tier Application Wizard Added support to Import/Export data-tier application with graph tables.
Flat File Import Wizard Added logic to notify the user that an import may have resulted in a renaming of the columns.
Integration Services (SSIS) Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are in Azure Government cloud.
Integration Services (SSIS) When you use SQL Agent of Azure SQL Managed Instance via SSMS, you can configure parameter and connection manager in SSIS agent job step.
Integration Services (SSIS) When connecting to Azure SQL Database / Azure SQL Managed Instance, you can connect to it with default as initial db.
Integration Services (SSIS) Added a new entry item Try SSIS in Azure Data Factory under "Integration Services Catalogs" node, which can be used to launch the "Integration Runtime Creation Wizard" and create "Azure-SSIS Integration Runtime" quickly.
Integration Services (SSIS) Added Create SSIS IR button in "Catalog Creation Wizard," which can be used to launch the "Integration Runtime Creation Wizard" and create "Azure-SSIS Integration Runtime" quickly.
Integration Services (SSIS) ISDeploymentWizard now supports SQL Auth, Azure Active Directory Integrated Auth, and Azure Active Directory Password Auth in command-line mode.
Integration Services (SSIS) Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS Integration Runtime.
Object Scripting Add new menu items for "CREATE OR ALTER" when scripting objects.
Query Store Improved usability of some reports (Overall Resource Consumptions) by adding thousands of separators to numbers displayed on the Y-axis of the charts.
Query Store Added a new Query Wait Statistics report.
Query Store Added "Execution Count" metric to "Tracked Query" View.
Replication Tools Added support for non-default port specification feature in Replication Monitor and SSMS.
ShowPlan Added actual time elapsed, actual vs. estimated rows under ShowPlan operator node if they're available. This makes the actual plan look consistent with Live Query Stats plan.
ShowPlan Modified tooltip and added comment when clicking on Edit Query Button for a ShowPlan, to indicate to user that the ShowPlan might be truncated by the SQL engine if the query is over 4000 characters.
ShowPlan Added logic to display the "Materializer Operator (External Select)".
ShowPlan Add new showplan attribute BatchModeOnRowStoreUsed to easily identify queries that are using the " batch-mode scan on rowstores" feature. Anytime a query performs batch-mode scan on rowstores, a new attribute (BatchModeOnRowStoreUsed="true") gets added to StmtSimple element.
ShowPlan Added Showplan Support to LocalCube RelOp for DW ROLLUP and CUBE.
ShowPlan New LocalCube operator for the new ROLLUP and CUBE aggregation feature in Azure Synapse Analytics.
SMO Extend SMO Support for Resumable Index Creation.
SMO Added new event on SMO objects ("PropertyMissing") to help application authors to detect SMO performance issues sooner.
SMO Exposed new DefaultBackupChecksum property on the Configuration object, which maps to the "backup checksum default" server configuration.
SMO Exposed new ProductUpdateLevel property on the Server object, which maps to the servicing level for the version of SQL in use (for example, CU12, RTM).
SMO Exposed new LastGoodCheckDbTime property on Database object, which maps to "lastgoodcheckdbtime" database property. If such property isn't available, a default value of 1/1/1900 12:00:00 AM is be returned.
SMO Moved location for RegSrvr.xml file (Registered Server configuration file) to "%AppData%\Microsoft\SQL Server Management Studio" (unversioned, so it can be shared across versions of SSMS).
SMO Added "Cloud Witness" as a new quorum type and as a new resource ty'e.
SMO Added support for "Edge Constraints" in both SMO and SSMS.
SMO Added cascade delete support to "Edge Constraints" in both SMO and SSMS.
SMO Added support for data classification "read-write" permissions.
Vulnerability Assessment Enabled Vulnerability Assessment tasks menu on Azure SQL DW.
Vulnerability Assessment Change the set of vulnerability assessment rules that are run on Azure SQL Managed Instance, so that "Vulnerability Assessment" scan results can be consistent with the ones in Azure SQL DB.
Vulnerability Assessment "Vulnerability Assessment" now supports Azure SQL DW.
Vulnerability Assessment Added a new exporting feature to export the vulnerability assessment scan results to Excel.
XEvent Viewer XEvent Viewer: enabled showplan window for more XEvents.

Bug fixes in 18.0

New item Details
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 Azure AD 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 Azure Active Directory (Azure AD).
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 Azure AD 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 Azure Active Directory (Azure AD) 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.
XEvent Viewer Fixed an issue where XEvent Viewer was crashing when trying to group the events using the "Extended Event Toolbar Options".

Deprecated and removed features in 18.0

Here are the deprecated and removed Features from SSMS version 18.0.

  • T-SQL Debugger
  • Database Diagrams
  • The following tools are no longer installed with SSMS:
    • OSQL.EXE
    • DReplay.exe
    • SQLdiag.exe
    • SSBDiagnose.exe
    • bcp.exe
    • sqlcmd.exe
  • Configuration Manager tools:
    • Both SQL Server Configuration Manager and Reporting Server Configuration Manager aren't part of SSMS setup anymore.
  • DMF Standard Policies
    • The policies aren't installed with SSMS anymore. They are moved to Git. Users are able to contribute and download/install them, if they want to.
  • SSMS command-line option -P removed
    • Due to security concerns, the option to specify clear-text passwords on the command line was removed.
  • Generate Scripts > Publish to Web Service removed
    • This deprecated feature was removed from the SSMS UI.
  • Removed node "Maintenance > Legacy" in Object Explorer.
    • The old "Database Maintenance Plan" and "SQL Mail" nodes won't be accessible anymore. The modern "Database Mail" and "Maintenance Plans" nodes continue to work as usual.

Known issues (18.0)

  • You might encounter an issue installing version 18.0, where you cannot run SQL Server Management Studio. If you encounter this issue, follow the steps from the SSMS2018 - Installed, but not run article.

  • There is a limitation on the size of the data you see from SSMS results shown in grid, text, or file

  • There are redraw issues when switching between multiple query windows. See SQL Server user feedback for more details. A workaround for this issue is to disable hardware acceleration under Tools > Options.

17.9.1

download Download SSMS 17.9.1

  • Release number: 17.9.1
  • Build number: 14.0.17289.0
  • Release date: November 21, 2018

Bug fixes in 17.9.1

  • Fixed an issue where users may experience their connection being closed and reopened with each query invocation when using "Azure Active Directory - Universal with MFA support" authentication with the SQL query editor. Side effects of the connection closing included global temporary tables being dropped unexpectedly, and sometimes a new SPID given to the connection.
  • Fixed a long outstanding issue where restore plan would fail to find a restore plan, or would generate an inefficient restore plan under certain conditions.
  • Fixed an issue in the "Import Data-tier Application" wizard, which could result in an error when connected to an Azure SQL Database.

Note

Non-English localized releases of SSMS 17.x require the KB 2862966 security update package if installing on: Windows 8, Windows 7, Windows Server 2012, and Windows Server 2008 R2.

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

Uninstall and reinstall SSMS 17.x

If your SSMS installation is having problems, and a standard uninstall and reinstall doesn't resolve them, you can first try repairing the Visual Studio 2015 IsoShell. If repairing the Visual Studio 2015 IsoShell doesn't resolve the problem, the following steps have been found to fix many random issues:

  1. Uninstall SSMS the same way you uninstall any application (using Apps & features, Programs, and features, depending on your version of Windows).

  2. Uninstall Visual Studio 2015 IsoShell from an elevated cmd prompt:

    PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"

    vs_isoshell.exe /Uninstall /Force /PromptRestart

  3. Uninstall Microsoft Visual C++ 2015 Redistributable the same way you uninstall any application. Uninstall both x86 and x64 if they're on your computer.

  4. Reinstall Visual Studio 2015 IsoShell from an elevated cmd prompt:

    PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"

    vs_isoshell.exe /PromptRestart

  5. Reinstall SSMS.

  6. Upgrade to the latest version of the Visual C++ 2015 Redistributable if you're not currently up to date.

16.5.3

download Download SSMS 16.5.3

  • Release number: 16.5.3
  • Build number: 13.0.16106.4
  • Release date: January 30, 2017

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

Bug fixes in 16.5.3

  • Fixed an issue introduced in SSMS 16.5.2, which was causing the expansion of the 'Table' node when the table had more than one sparse column.

  • Users can deploy SSIS packages containing OData Connection Manager, which connect to a Microsoft Dynamics AX/CRM Online resource to SSIS catalog. For more information, For details, see OData Connection Manager.

  • Configuring Always Encrypted on an existing table fails with errors on unrelated objects. Connect ID 3103181

  • Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect ID 3109591

  • The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect ID 3111925

  • When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.

  • Open recent menu doesn't show recently saved files. Connect ID 3113288

  • SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection). Connect ID 3114074

  • Fixed an issue with the SQL Designer scrollbar. Connect ID 3114856

  • Context menu for tables momentarily stops responding

  • SSMS occasionally throws exceptions in Activity Monitor and crashes. Connect ID 697527

  • SSMS 2016 crashes with error "The process was terminated due to an internal error in the .NET Runtime at IP 71AF8579 (71AE0000) with exit code 80131506"

Additional Downloads

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

For the latest release of SQL Server Management Studio, For details, see Download SQL Server Management Studio (SSMS).