- Docs
- /
Release Notes
06 Jun 2022 52401 views 0 minutes to read Contributors 
This article provides details about updates, improvements, and bug fixes for the current and previous versions of SSMS.
Note
In December 2021, releases of SSMS prior to 18.6 will no longer authenticate to Database Engines through Azure Active Directory with MFA. To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later.
Connectivity to Azure Analysis Services through Azure Active Directory with MFA requires SSMS 18.5.1 or later.
Current SSMS release
Download SQL Server Management Studio (SSMS) 18.10
SSMS 18.10 is the latest general availability (GA) release of SSMS. If you need a previous version of SSMS, see previous SSMS releases.
18.10
- Release number: 18.10
- Build number: 15.0.18390.0
- Release date: October 5, 2021
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.10
| New item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.32.0. |
| Analysis Services | Update BITools to 150.19714.0 |
| DacFx | Update DacFx to 15.0.5282.3 |
| Import Flat File | Support for rich data types in Import Flat File wizard, including money. |
| Replication | Support for scripting of peer to peer publication with Last Writer Win (LWW) conflict detection |
| XEvents | Support for Ledger syntax in XEvents interface |
Bug fixes in 18.10
| New Item | Details |
|---|---|
| Accessibility | Fixes a narrator issue in the Data Classification Pane |
| Accessibility | Fixes a visibility issue in the Data Classification Pane |
| Azure SQL DW | Fixes an issue where trying to create an Azure SQL DW database throws an error. |
| Backup | Fixes an issue where SSMS restore backup from URL fails on Azure storage account SKU. |
| High DPI / Scaling | Fixes high-DPI issue in SSIS Job Step |
| High DPI / Scaling | Fixes high-DPI issue in Object Dependencies |
| High DPI / Scaling | Fixes high-DPI issue in Replication Wizard |
| High DPI / Scaling | Fixes high-DPI issue in table trigger object explorer menu item |
| Import Flat File | Clarifies error reporting option in Import Flat File wizard. |
| Profiler | Fixes an issue where Profiler client crashes with an internal error on table-valued parameter with a missing default value. |
| Reports | Fixes an issue with a Resource Locking Statistics report not filtering on resource database. |
| SqlParser | Fixes an issue where Azure tables fail to script when database catalog collation is case sensitive. |
| XEvents | Fixes issue where long string does not include ellipsis at end when truncated in display |
Known issues (18.10)
| New Item | Details | Workaround |
|---|---|---|
| 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. | Uninstalling and reinstalling SQL Server Management Studio. If not solved by reinstallation, close all instances of SSMS, backup and then remove %AppData%\Microsoft\SQL Server Management Studio and %LocalAppData%\Microsoft\SQL Server Management Studio. |
| 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. | Remove folder "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild". |
You can reference SQL Server user feedback for other known issues and to provide feedback to the product team.
Previous SSMS releases
Previous SSMS releases
Download previous SSMS versions by selecting the download link in the related section.
| SSMS version | Build number | Release date |
|---|---|---|
| 18.12 | 15.0.18420.0 | June 9, 2022 |
| 18.11.1 | 15.0.18410.0 | March 8, 2022 |
| 18.11 | 15.0.18404.0 | February 24, 2022 |
| 18.10 | 15.0.18390.0 | October 5, 2021 |
| 18.9.2 | 15.0.18386.0 | July 15, 2021 |
| 18.9.1 | 15.0.18384.0 | April 20, 2021 |
| 18.9 | 15.0.18382.0 | April 15, 2021 |
| 18.8 | 15.0.18369.0 | December 17, 2020 |
| 18.7.1 | 15.0.18358.0 | October 27, 2020 |
| 18.7 | 15.0.18357.0 | October 20, 2020 |
| 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.12
- Release number: 18.12
- Build number: 15.0.18420.0
- Release date: June 09, 2022
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.12
| New Item | Details |
|---|---|
| Always Encrypted | Updated AE Tools to only show keys with no expiration date. |
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.36.2. |
| Compatibility Mode | Added support for compatibility mode 160. Note that SSMS 19 is the recommended SSMS release for use with SQL Server 2022. Visit Download SQL Server Management Studio 19 to obtain SSMS 19. |
| Data Classification | Improvements to Data Classification user interface. |
| Link feature for Azure SQL Managed Instance | Added the link feature support for SQL Server 2016 for connection and failover wizards. See Link feature for Azure SQL Managed Instance. |
| Link feature for Azure SQL Managed Instance | Added failover wizard support to migrate multiple databases at the time from SQL Server to Azure SQL Managed Instance using the link feature. |
| Query Editor | Added a dialog to allow users to cancel the transaction count check if it takes longer than two seconds when closing the query editor window. |
| Query Tuning Advisor | Updated user interface for improved accessibility. |
| Showplan | The Showplan XML schema has been updated to include new attributes related to the Query Store Hint feature. |
Bug fixes in 18.12
| New Item | Details |
|---|---|
| Availability Group Dashboard | Fixed issue when connecting to the Availability Group Dashboard for an AG on SQL Server 2016 which resulted in "unknown property ClusterType" error. See SSMS 18.11.1 Bug. |
| Analysis Services | Corrected behavior of SSMS not saving Analysis Services settings separately. |
| Integration Services | Fixed an issue that caused the error "System.ArgumentException: Value does not fall within the expected range" that would be encountered unexpectedly at step "Changing protection level" when deploying SSIS project. |
| General SSMS | Fixed issue with Technical Support menu link opening to a blank page. |
| Intellisense | Fixed Intellisense for contained users. |
| Ledger | Fixed issue with display columns and ledger tables displaying more than once. |
| Link feature for Azure SQL Managed Instance | Fixed issues related to the automated connection and failover wizards for the link feature. |
| Query Editor | Fixed issue with audible notification occurring when closing a query window. See SSMS 18.11.1 Beeps When I Close a Query Window. |
| Registered Servers | Fixed issue that caused SSMS crash when displaying registered servers after importing registered servers from Azure Data Studio via settings.json file. See SSMS (18.11.1) crashing on "show registered servers". |
| Partitioning | Addressed missing option to schedule Agent job in the partitioning wizard. |
Known issues (18.12)
18.11.1
- Release number: 18.11.1
- Build number: 15.0.18410.0
- Release date: March 08, 2022
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.11.1
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.35.0. |
| Data Classification | Introduced Set Microsoft Information Protection Policy menu option. |
| Data Classification | Added M365 authentication window to set MIP policy. |
| Data Classification | Classify Data page and Add Classification page display the M365 sensitivity labels when in MIP policy mode. |
| Data Classification | Added warning icon against the columns if the prior classification and current Information Protection policy mode doesn’t match. |
| Link feature for Azure SQL Managed Instance | Introduced connection wizard to assist with establishing a hybrid link between SQL Server and Managed Instance. See Link feature for Azure SQL Managed Instance. |
| Link feature for Azure SQL Managed Instance | Introduced failover wizard to assist with migration of databases from SQL Server to Azure SQL Managed Instance using the link feature. |
| Link feature for Azure SQL Managed Instance | Introduced dashboard to monitor the status of the hybrid link established between SQL Server and Managed Instance. |
Known issues (18.11.1)
18.11
- Release number: 18.11
- Build number: 15.0.18404.0
- Release date: February 24, 2022
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.11
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.34.0. |
| Data Classification | Updated user interface Modified the Data Classification UI panel to allow users to select specific Schema & Table to display classified columns. |
| Data Classification | Updated the Add Classification pane to allow users to add new classifications for columns that are not yet classified. |
| Data Classification | Added a new category, All Unclassified, in the Column drop down of the Add Classification page. |
| Data Classification | Updated the Recommendations pane to allow Save selected recommendations directly after scanning the entire database. |
| General SSMS | Added a dialog box to display the status of an extended open transaction check when closing a T-SQL Query Editor tab. |
| Profiler | Added support for trace files from Analysis Services version 16.0. |
| Profiler | Added ability to carry over the password from an existing connection when starting SQL Profiler from SSMS. |
Bug fixes in 18.11
| New Item | Details |
|---|---|
| Accessibility | Fixed focus order for ease of navigation and corrects names read by screen reader in View Facets window. |
| Accessibility | Improved names read by Screen Readers in Database properties window. |
| Accessibility | Fixed contrast and accessible names in Data Classification Report. |
| Accessibility | Multiple Screen reader fixes in the Data Classification Pane. |
| Accessibility | Fixed issue with loss of focus indication in Data Classification Pane. |
| Always Encrypted | Fixes issue with the New Column Master Key wizard freezing up when creating Always Encrypted column master key using Azure Key Vault as the key store, with the key vault having any of the Rotate key permissions set. |
| Analysis Services | Updated Analysis Services dependencies. |
| General SSMS | Fixed icon consistency for temporal tables. |
| General SSMS | Fixed an issue where SSMS could show an error dialog with an unhelpful message (e.g. "syntax error ( *EngineEdition != 11)" ). |
| General SSMS | Updated Technical Support URL to point to sqlfeedback site. |
| General SSMS | Fixed issue with SSMS crashing due to incorrect grid width. |
| General SSMS | Fixed issue with arithmetic overflow error in backup system query. |
| Import/Export Data-Tier Application | Resolved issue with Bacpac wizard failing when browsing storage accounts. |
| Ledger Tables | Ledger objects are visually indicated as such in Object Explorer, history tables are nested under their respective ledger tables, and template ledger table scripts have been added. |
| Profiler | Fixed an issue where SSMS was not able to start SQL Profiler when spaces existed between the server name and its port number. |
| SQL Agent (Managed Instance) | Fixed an issue that prevented creating or adding a step to new or existing SQL Agent job. See SSMS error while editing job step. |
| Showplan | Ability to zoom in and out of plans with CTRL + mousewheel. See SQL Server user feedback. |
| SMO/Scripting | Added support to script External Streaming Jobs when scripting Databases. |
| SSMS Setup | Fixed an issue in the Analysis Services deployment wizard for the JPN SSMS executable. |
| SSMS Setup | Fixed an issue where SSMS setup could fail with an 'Element not found (0x80070490)" [Failed to find expected public key in certificate chain]. |
| SSMS Setup | Fixed an issue to support SSMS migrations to later versions. |
Known issues (18.11)
18.10
- Release number: 18.10
- Build number: 15.0.18390.0
- Release date: October 5, 2021
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.10
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.32.0. |
| Analysis Services | Update BITools to 150.19714.0 |
| DacFx | Update DacFx to 15.0.5282.3 |
| Import Flat File | Support for rich data types in Import Flat File wizard, including money. |
| Replication | Support for scripting of peer to peer publication with Last Writer Win (LWW) conflict detection |
| XEvents | Support for Ledger syntax in XEvents interface |
Bug fixes in 18.10
| New Item | Details |
|---|---|
| Accessibility | Fixes a narrator issue in the Data Classification Pane |
| Accessibility | Fixes a visibility issue in the Data Classification Pane |
| Azure SQL DW | Fixes an issue where trying to create an Azure SQL DW database throws an error. |
| Backup | Fixes an issue where SSMS restore backup from URL fails on Azure storage account SKU. |
| High DPI / Scaling | Fixes high-DPI issue in SSIS Job Step |
| High DPI / Scaling | Fixes high-DPI issue in Object Dependencies |
| High DPI / Scaling | Fixes high-DPI issue in Replication Wizard |
| High DPI / Scaling | Fixes high-DPI issue in table trigger object explorer menu item |
| Import Flat File | Clarifies error reporting option in Import Flat File wizard. |
| Profiler | Fixes an issue where Profiler client crashes with an internal error on table-valued parameter with a missing default value. |
| Reports | Fixes an issue with a Resource Locking Statistics report not filtering on resource database. |
| SqlParser | Fixes an issue where Azure tables fail to script when database catalog collation is case sensitive. |
| XEvents | Fixes issue where long string does not include ellipsis at end when truncated in display |
Known issues (18.10)
18.9.2
- Release number: 18.9.2
- Build number: 15.0.18386.0
- Release date: July 15, 2021
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.9.2
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.30.0. |
| Always Encrypted | Scripting support for Ledger tables. |
| Analysis Services | Support for XMLA endpoint to refresh datasets in PowerBI premium Gen 2. |
| Azure SQL DB | Adds support for backup_storage_redundancy in database create/modify dialogs. |
| Azure SQL DB | Adds create login script support for AAD-based login syntax. |
| Integration Services | Improvement for IR Creation Wizard, Job Migration Wizard and SSIS package scheduler to support AzureUSGovernment and AzureChinaCloud. |
| Intellisense | Syntax highlighting for External Language Management and Query Store (query_store_plan_feedback, query_store_query_variant). |
Bug fixes in 18.9.2
| New Item | Details |
|---|---|
| Accessibility | Fixes issue in screen reader announcements for dialogs processing information. |
| Always Encrypted | Fixes issue where sign-in button wasn't fully visible during Master Key Configuration. |
| Azure SQL DB | Fixes issue where multiple tenants on an account made SLO changes from database properties unreliable. |
| Backup/Restore | Fixes issue where browse folder dialog was incorrectly parsing the root of a drive. |
| Backup/Restore | Fixes issue in restoring a database to point in time using timeline dialog. |
| General SSMS | Fixes open SqlConnection leaks in object explorer. |
| High DPI / Scaling | 4k Scaling Fixes in dialogs for Publication Properties, Extended Events, Always Encrypted, Copy Database Wizard, and Database Designer. |
| Maintenance Plan | Fixes an issue where deleting a maintenance plan removed a DTS package from the server. |
| Object Explorer | Fixes issue where "Storage" menu item wasn't appearing for Azure SQL Managed Instance. |
| Replication Tools | Fixes an issue where the script generated is incorrect while configuring ReadOnly Routing. |
| XEvents | Fixes issue where line endings weren't properly displayed in a XEvent popup dialog. |
Known issues (18.9.2)
18.9.1
- Release number: 18.9.1
- Build number: 15.0.18384.0
- Release date: April 20, 2021
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.9.1
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.28.0. |
Bug fixes in 18.9.1
| New Item | Details |
|---|---|
| IntelliSense | Fixed issue where column names were omitted from suggestions and error indicators are falsely displayed under the column names. SQL Server user feedback |
Known issues (18.9.1)
18.9
- Release number: 18.9
- Build number: 15.0.18382.0
- Release date: April 15, 2021
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.9
| New Item | Details |
|---|---|
| Always Encrypted | Updated the New Column Master Key and New Column Encryption Key dialogs to support provisioning and managing column master keys stored in Azure Key Vault Managed HSMs. |
| Always Encrypted | Enabled specifying a key length when generating column master keys in Azure Key Vault. |
| Always Encrypted | Improved diagnostics for provisioning and managing column master keys stored in Azure Key Vault. |
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.27.0. |
| Azure SQL DB | Improved the diagnostic reporting when an error occurs while interacting with Azure. |
| General SSMS | Added command /resetuserdata to ssms.exe, which resets the user data including the "Most Recently Used" lists. |
| General SSMS | Updated MSODBC and OLEDB drivers installed with SSMS. The updated version to MSODBC notably adds a workaround to connection error AADSTS530000 (AAD configuration with Conditional Access policies that would require Windows Account Manager). See Using Azure Active Directory for more information. |
| IntelliSense/Editor | Added support for greatest and least in IntelliSense |
| IntelliSense/Editor | Added support for BACKUP_STORAGE_REDUNDANCY syntax (CREATE/ALTER DATABASE). |
| ShowPlan | Always show Estimated Number of Rows for All Executions property |
Bug fixes in 18.9
| New Item | Details |
|---|---|
| Accessibility | Fixed issues in narrator: Items order for New Column Master Key UI to move in a logical order from top to bottom, Narrator focus order on Filter Settings. |
| Always Encrypted | Fixed the Always Encrypted wizard to not include a port number in key paths for column master keys stored in Azure Key Vault. The bug caused failures in the ODBC and PHP drivers that didn't expect port numbers in key paths. |
| Always On Availability Group | Fixed in issue where the "Add New Availability Group" Wizard doesn't join AG databases into new AG automatically on secondary replica. |
| Auditing | Fixed an issue where SSMS was throwing an error dialog when trying to bring up the Properties on Audit Specification. |
| Auditing | Fixed an issue were some Audit Specifications wizards and property dialogs where not working properly on some localized versions of SSMS (e.g. Create, Japanese). |
| Azure SQL DB | Fixed an issue that was causing the "Create firewall rule" to fail in some cases. |
| Azure SQL DB | Fixed an issue where the "Properties" dialog on a Table was displaying the incorrect server name (local machine instead of the Azure SQL DB server name). |
| Azure SQL DB | Fixed an issue that was causing the "Create firewall rule" to fail when the server name had invalid characters (such as capital letters) in the name. |
| Import/Export Data-Tier Application | Fixed in issue where importing a bacpac into SQL Express may fail. See SQL Server user feedback. |
| General SSMS | Fixed a crash (in the Visual Studio Shell) that was causing SSMS to crash when re-docking tabs. See SQL Server user feedback |
| General SSMS | Fixed an issue in "Browse folder" dialog that was causing SSMS to stop responding. |
| General SSMS | Fixed an issue where Object Explorer can lock up the UI thread, and ultimately cause the UI to freeze (and the user to have to hard close the SSMS. |
| General SSMS | Addressed issue where there's no option available in SSMS to rebuild a clustered columnstore index online. SSMS offers an online ON checkbox on the UI, where we can select if the particular index has to be built online. |
| General SSMS | Fixed the logic to page the user to a proper page in most error dialogs originating from exception at the SQLClient (driver) level. Previously, for almost all the error/exceptions, the help button was always tasking the user to a non-existing page. |
| General SSMS | Fixed issues around the "Server Properties / Processor" UI where SSMS is SSMS shows incorrect CPU Processor information or an error similar to "An item with the same key has already been added." See SQL Server user feedback and another SQL Server user feedback. |
| General SSMS | Fixed errors that may show up while resetting settings. See SQL Server user feedback. |
| General SSMS | Fixed an issue that was causing SSMS to throw an error message when trying to use the "PresentOn" feature in QuickLaunch. Also, added back the "PresentOff " functionality, which resets the UI to its regular size. |
| General SSMS | Fixed the logic that prevents the creation of a (clustered) columnstore index, which was overly restrictive for newer versions of SQL Server. See SQL Server user feedback. |
| General SSMS | Fixed an issue where SSMS was displaying an incorrect error message when changing the connection of an editor window to DAC ("Dedicated Admin Connection"). The error message was misleading in asserting that the connection wasn't successful, when indeed it was. Note: while the error has been removed, due to the nature of DAC, keep in mind that: (1) IntelliSense experience will be significantly limited (2) SSMS will still block the Object Explorer experience when connecting using DAC. |
| High DPI/Scaling | Fixed an issue where the Data Collection Wizard could UI could result in being clipped on High DPI monitors (at 150% scaling). |
| High DPI/Scaling | Fixed an issue where DB Mirroring security wizard may render poorly on High DPI (at 150% scaling). |
| High DPI/Scaling | Fixed an issue with the "New Job Schedule" dialog which was rendering poorly on High DPI (4K monitors and 200% scaling). |
| High DPI/Scaling | Fixed an issue with the "New Session" (XEvents) where some elements of the UI were truncated on High DPI (4K monitors and 200% scaling). |
| Import Flat File | Fixed issue where some messages displayed by the Import Flat File wizard aren't localized. |
| Integration Services | Previous known issue "Remote connections to Integration services may fail with "The specified service doesn't exist as an installed service." on newer Operating system." is corrected by a fix delivered with the OS. |
| IntelliSense/Editor | Updated IntelliSense to display more useful information on built-in functions TODATETIMEOFFSET and SWITCHOFFSET. |
| Log Shipping Wizard | Fixed in issue where Log Shipping Wizard may throw an error "Can’t show requested dialog" when clicking on Edit Job for Transaction Log Backup/Copy/Restore Setting Tab. |
| Log Viewer | Addressed an issue where on some locales (e.g. Korean) some UI elements looked truncated/clipped. |
| Maintenance Plans | Fixed an issue where SQL Server Management Studio 15.0.18338.0 can't explore "Expression" property in Maintenance plan. See SQL Server user feedback. |
| Query Tuning Advisor | Fixed an issue where an error message like "User doesn't have enough permissions." was displayed when trying to use the "New Database Upgrade Session" wizard on a database containing a dot in the name. See SQL Server user feedback. |
| SMO/Scripting | Fixed script generation for DW databases where it only worked if the object explorer was connected to logical master instead of the user database. |
| SSMS Setup | Fixed an issue where SSMS Setup wasn't properly executing the Post-Install Custom Action, thus not running "ssms.exe /setup". This is believe to be the cause for some sporadic issues when SSMS is started after an upgrade (see known issue session for AS). |
| Vulnerability Assessment | Disabling menu options "Tasks -> Vulnerability Assessment" for Azure SQL databases and adding collapsible message tip for better user experience for Azure SQL VM users. |
| XEvent UI | Fixed capability to filter Extended Events using the event name instead of ID. Supports the use of map_value column instead of map_key in wait_type filter predicate as the key value is subjected to change during version upgrade. Originally added in SSMS 18.8. |
Known issues (18.9)
18.8
- Release number: 18.8
- Build number: 15.0.18369.0
- Release date: December 17, 2020
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
What's new in 18.8
| New Item | Details |
|---|---|
| Azure Data Studio installation integration | Installation of SSMS installs Azure Data Studio 1.25.1. |
| Analysis Services | Added support for Power BI Premium Gen2 workspaces. |
| Auditing | Added support for EXTERNAL_MONITOR and "operator audit". See the configuration documentation for more information. |
| Integration Services | Improved IR Creation Wizard such that creating SSISDB is optional when creating SSIS IR |
Bug fixes in 18.8
| New Item | Details |
|---|---|
| Accessibility | Fixed issues impacting Narrator in the ProgressReport Dialog |
| Activity Monitor | Fixed an issue where the "Edit Query Text" context menu in "Active Expensive Queries" grid wasn't working |
| Always Encrypted | Fixed an issue where SSMS could throw a runtime error ("Class not found") |
| High DPI/Scaling | Improved the 4k display of the ProgressReport Dialog |
| High DPI/Scaling | Fixed in issue on the "New Schedule- Package" Form in Integration Services |
| General SSMS | Fixed an issue where SSMS could be throwing an error when trying to display the properties of a column which has an identity seed or identity increment that exceeds the size of a bigint. |
| General SSMS | Fixed a crash in SSMS caused by a menu item "Projects Export Templates…" which wasn't meant to be displayed |
| General SSMS | Fixed an issue that could cause SSMS to crash when enumerating backups in a folder |
| General SSMS | Mitigated an issue that was causing SSMS to leak handles and memory when displaying results of queries |
| General SSMS | Fixed an issue where the users weren't able to create clustered columnstore index for columns of particular types (UniqueIdentifier on SQL 2014 and above, VarCharMax/NVarCharMax/VarBinaryMax on SQL 2017 and above) |
| General SSMS | Fixed a long outstanding issue where the reordering of XML columns in the "Result Grid" wasn't working. See SQL Server user feedback |
| General SSMS | Fixed issue where SSMS was incorrectly displaying a warning about "change tracking not being supported for a database with memory optimized objects " |
| Generate Scripts Wizard | Fixed a bug inhibiting enumeration of database objects on SQL Server 2014 and older. See SQL Server user feedback. |
| Replication Tools | Fixed an issue where SQL Replication Monitor wasn't honoring the autoconnect settings, thus forcing the user to manually reconnect every time. See SQL Server user feedback |
| SMO/Scripting | Fixed an issue when trying to use "Generate Script…" on an encrypted view in SQL Azure DB |
| XEvent UI | Fixed an issue that could cause SSMS to crash when switching from other applications to SSMS. |
| XEvent UI | Reverted the improvement from 18.7 that caused a bug in XEvent creation due to additional quotation marks. This change is temporary and the improvement will return in a subsequent release without the accompanying bug. |
Known issues (18.8)
18.7.1
- Release number: 18.7.1
- Build number: 15.0.18358.0
- Release date: October 27, 2020
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish
Bug fixes in 18.7.1
| New Item | Details |
|---|---|
| Query Store | Fixed error thrown when right-click on the object explorer node for Query Store. |
Known issues (18.7.1)
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
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's 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 wasn't 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 stop responding 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 wasn't 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 serverless SQL pool 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 wasn't 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 can’t be enabled in IR Creation Wizard. |
| Integration Services | Fixed an issue that items of "Use Environment variable" ComboBox in "Set Parameter Value" dialog aren't 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) wasn't able to add a linked server. |
| Log Viewer | Fixed an issue where a user with VIEW SERVER STATE permissions wasn't 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 wasn't landing on the correct page on DOCS. |
| XEvent UI | Fixed log in XEvent Viewer where the tooltip wasn't displaying correctly text containing text encoded using surrogate pairs. |
Known issues (18.7)
| New Item | Details | Workaround |
|---|---|---|
| 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 |
| Generate Scripts Wizard | The wizard fails when attempting to enumerate database objects on SQL Server 2014 and older. See SQL Server user feedback. | Use SSMS 18.6 to select objects in the generate scripts wizard for SQL 2014 and older. |
| 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 serverless SQL pool. | To continue utilizing object explorer in SSMS with Azure Synapse Analytics serverless SQL pool, 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. |
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're 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. |
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 isn't 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 doesn't 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 aren't 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 wasn't 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. | Upgrade to SSMS 18.7 or newer. |
| 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
- 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's 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
- 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 Azure Synapse Analytics serverless SQL pool. |
| 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 isn't logical in the scan mode of narrator under New Schedule wizard. |
| Accessibility | Stretch database wizard: fixed an issue where the screen reader doesn't 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 doesn't 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 Azure Synapse Analytics serverless SQL pool. |
| General SSMS | Fixed New External Table... and New External Data Source... templates for Azure Synapse Analytics serverless SQL pool. |
| General SSMS | Fixed database properties, connection properties, hiding reports and rename for Azure Synapse Analytics serverless SQL pool. |
| 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" doesn't 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 wasn't 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 wasn't 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 wasn't 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 aren't determined at runtime). Also SSMS isn't disabling the "View" button when the user doesn't 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 Azure Synapse Analytics serverless SQL pool. |
| 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 wasn't 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).
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 Azure Synapse Analytics serverless SQL pool. |
| 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
- 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
- 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
- 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
- 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. For more information, see 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
- 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:
-
Uninstall SSMS the same way you uninstall any application (using Apps & features, Programs, and features, depending on your version of Windows).
-
Uninstall Visual Studio 2015 IsoShell from an elevated cmd prompt:
PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"vs_isoshell.exe /Uninstall /Force /PromptRestart -
Uninstall Microsoft Visual C++ 2015 Redistributable the same way you uninstall any application. Uninstall both x86 and x64 if they're on your computer.
-
Reinstall Visual Studio 2015 IsoShell from an elevated cmd prompt:
PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"vs_isoshell.exe /PromptRestart -
Reinstall SSMS.
-
Upgrade to the latest version of the Visual C++ 2015 Redistributable if you're not currently up to date.
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).
