Release notes for SQL Server Management Studio (SSMS)

29 Sep 2019 0 minutes to read Contributors

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

SSMS 18.2

Download: Download SSMS 18.2
Build number: 15.0.18142.0
Release date: July 25, 2019

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

18.2 is an update to 18.1 with the following new items and bug fixes.

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 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 Feature Restrictions. For more information on the feature itself, see Feature Restrictions.
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 UserVoice 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 UserVoice
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 defaults values when creating an Azure SQL Database.
General SSMS Fixed an issue where the user was not 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 was not working after upgrading from SSMS 18.0 to 18.1. See UserVoice
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 UserVoice 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 UserVoice for more details.
Object Explorer Fixed an issue where renaming databases was causing incorrect database names to show up in Object Explorer. See UserVoice 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 did not 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 was not 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 UserVoice for more details.
SMO/Scripting Fixed an issue where CREATE OR ALTER was not scripting objects that had extended properties on them. See UserVoice for more details.
SMO/Scripting Fixed an issue where SSMS wasn't able to script CREATE EXTERNAL LIBRARY correctly. See UserVoice 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 did not work.
SMO/Scripting Fixed an issue where scripting of External Data Source on SQL 2019 did not work. See UserVoice for more details.
SMO/Scripting Fixed an issue where * extended properties* on columns weren't scripted when targeting Azure SQL DB. 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 UserVoice 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 UserVoice for more details.

  • SSMS 18.0 redraw issues when switching between multiple query windows. See UserVoice. A workaround for this issue is to disable hardware acceleration under Tools > Options.

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

You can reference UserVoice for other known issues and to provide feedback to the product team.

Previous SSMS releases

Download previous SSMS versions by clicking the title links in the following sections:

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

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

18.1 is a small update to 18.0 with the following new item and bug fixes.

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 Database managed instance.

Bug fixes in 18.1

New Item Details
Accessibility Improved accessibility of the Agent Job UI.
Accessibility Improved accessibility on 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 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 on some localized version of SSMS.
High DPI Fixed layout of New Job Schedule page. See UserVoice 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 databases 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 UserVoice for more details.
SSMS setup Fixed the issue that was causing SSMS set up to fail when the setup log path contained spaces. See UserVoice for more details.
SSMS setup Fixed an issue where SSMS was exiting immediately after showing the splash screen.
See these sites for more details: UserVoiceSSMS 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 UserVoice for more details.
Reports Correcting report to display GrantedQueryMemory in KB (SQL Performance Dashboard report). See UserVoice 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 UserVoice 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 UserVoice 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 grid, text, or file

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)FrenchGermanItalianJapaneseKoreanPortuguese (Brazil)RussianSpanish

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 databases.
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 "AAD logins" as a new login type in SMO and SSMS when connected to an 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 preview: 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.
Audit Files Updated list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP.
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 DB/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 SQL Data Warehouse.
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 will 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 type.
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 servers, so that "Vulnerability Assessment" scan results will 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 a hang when connecting to an Azure SQL DB using MFA while ADAL traces are enabled.
Crashes and freezes Fixed a hang (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 hang 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 SSSM 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 hang in Object Explorer by optimizing the way IsFullTextEnabled property is retrieved.
Crashes and freezes Fixed a hang 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 hang/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 could not 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 DB 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 DB 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 DB managed instance support "Generate and Publish scripts" wizard scripts unsupported CREATE DATABASE clauses.
Azure SQL DB managed instance support Enable Live Query Statistics for managed instances.
Azure SQL DB managed instance support Database properties->Files was incorrectly scripting ALTER DB ADD FILE.
Azure SQL DB managed instance support Fixed regression with SQL Agent scheduler where ONIDLE scheduling was chosen even when some other scheduling type was chosen.
Azure SQL DB managed instance support Adjusting MAXTRANSFERRATE, MAXBLOCKSIZE for doing backups on Azure Storage.
Azure SQL DB managed instance support The issue where tail log backup is scripted before RESTORE operation (this isn't supported on CL).
Azure SQL DB managed instance support Create database wizard not scripting correctly CREATE DATABASE statement.
Azure SQL DB managed instance support Special handling of SSIS packages within SSMS when connected to managed instances.
Azure SQL DB managed instance support Fixed an issue where an error was displayed while trying to use "Activity Monitor" when connected to managed instances.
Azure SQL DB managed instance support Improved support for AAD Logins (in SSMS Explorer).
Azure SQL DB managed instance support Improved scripting of SMO Filegroups objects.
Azure SQL DB managed instance support Improved UI for credentials.
Azure SQL DB managed instance support Added support for Logical Replication.
Azure SQL DB managed instance support Fixed an issue, which was causing right-clicking on a database and choosing 'Import data-tier application' to fail.
Azure SQL DB managed instance support Fixed an issue, which was causing right-clicking on a "TempDB" to show errors.
Azure SQL DB 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 DB managed instance support Improved display of managed instances server-specific properties (hardware generation, service tier, storage used and reserved).
Azure SQL DB 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 floats 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 will be in SSMS 17.9] 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 will fail 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 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/33073510https://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 DB 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 DB 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 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 did not 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 will now by default disable automatic download of DTD in XMLA editor -- XMLA script editor (which uses the xml language service) will by default now prevent 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 are not 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

Deprecated / Removed Features

  • 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 are not part of SSMS setup anymore.
  • DMF Standard Policies
    • The policies are not installed with SSMS anymore. They will be moved to Git. Users will be 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 really old "Database Maintenance Plan" and "SQL Mail" nodes won't be accessible anymore. The modern "Database Mail" and "Maintenance Plans" nodes will 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, please follow the steps from the SSMS2018 - Installed, but will not run article.

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

download SSMS 17.9.1

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

17.9.1 is a small update to 17.9 with the following bug fixes:

  • 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)FrenchGermanItalianJapaneseKoreanPortuguese (Brazil)RussianSpanish

download SSMS 16.5.3

Generally available| Build number: 13.0.16106.4

Chinese (Simplified)Chinese (Traditional)English (United States)FrenchGermanItalianJapaneseKoreanPortuguese (Brazil)RussianSpanish

The following issues were fixed this release:

  • 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 hangs

  • 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"

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.

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).

Source: Microsoft, https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms

In this article