SQL Server Management Studio - Changelog (SSMS)

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

SSMS 17.3

Generally available | Build number: 14.0.17199.0

Enhancements

  • New "Import Flat File" wizard added to streamline the import experience of CSV files with an intelligent framework, requiring minimal user intervention or specialized domain knowledge. For details, see Import Flat File to SQL Wizard.
  • Added "XEvent Profiler" node to Object Explorer. For details, see Use the SSMS XEvent Profiler.
  • Updated waits filtering and categorization in Performance Dashboard historical waits report.
  • Added the syntax check of the "Predict" function.
  • Added the syntax check of the External Library Management queries.
  • Added SMO support for External Library Management.
  • Added "Start PowerShell" support to "Registered Servers" window (requires a new SQL PowerShell module).
  • Always On: added read-only routing support for availability groups.
  • Added an option to send tracing details to the Output Window for "Active Directory - Universal with MFA support" logins (off by default; needs to be turned on in user settings under "Tools > Options > Azure Services > Azure Cloud > ADAL Output Window Trace Level").
  • Query Store:
    • Query Store UI will be accessible even when QDS is OFF as long as QDS have recorded any data.
    • Query Store UI now exposes waits categorization in all the existing reports. This will let customers unlock the scenarios of Top Waiting Queries and many more.
  • Made inclusion of the scripting parameters headers optional (off by default; can be enabled in user settings under "Tools > Options > SQL Server Object Explorer > Scripting > Include scripting parameters header") - Connect item 3139199.
  • Removed "RC" branding.

Bug Fixes

General SSMS

  • XEvent:
    • Fixed issue where SSMS opens only part of the events in .xel file.
    • Improved “Watch Live Data” experience when default database is not 'master' - Connect item 1222582.
  • Always On: Fixed issue where "Restore log backups" may fail with error "The log in this backup set terminates at LSN x, which is too early to apply to the database".
  • Job Activity Monitor: fixed inconsistent icons - Connect item 3133100.
  • Query Store: Fixed Issue where user cannot choose "custom" date range for Query Store reports. Linked to below connect items.
  • Fixed issue where connection dialog doesn't "clear" the most recently used database when saved info has named database and user selects .
  • Object Scripting:
    • Fixed an issue where "Generate database script" not working and throwing an error when the user has a paused DW database on the server, but selected another non-DW database and tried t script it.
    • Fixed issue where the header for scripted Stored Procedures was not matching the script settings, resulting in a misleading script - Connect item 3139784.
    • Re-enabled the "Script button" when targeting SQL Azure objects.
    • Fixed issue where SSMS was not allowing scripting for "Alter" or "Execute" on some objects (UDF, View, SP, Trigger) when connected to an Azure SQL database - Connect item 3136386.
  • Query editor:
    • Improved intellisense when targeting Azure SQL databases.
    • Fixed an issue where queries failed due to an expired authentication token (Universal Authentication).
    • Improved intellisense when working against Azure SQL databases (particularly, when connecting to Azure SQL Database, the latest T-SQL grammar (140) will be used).
    • Fixed issue where open a query window with a connection to a non-DataWarehouse database on a server would cause all subsequent query windows for that server to DataWarehouse databases to throw various errors about unsupported types/options.
  • Always On:
    • Added seeding mode column to Always On dashboard and AG properties page.
    • Fixed issue where it was not possible to create a Linux AG when primary is on Windows - Connect item 3139856.
  • Fixed several "Out of Memory" issues in SSMS when running queries - Connect item 2845190, Connect item 3123864.
  • Profiler:
    • Fixed issue were Profiler was not working when targeting SQL 2005.
    • Fixed issue where Profiler was not honoring the "trust server certificate" connection option.
  • Activity Monitor: fixed an issue where Activity Monitor does not work when pointed at SQL Server running on Linux.
  • Fixed an issue with the SMO Transfer class where it wouldn’t transfer External Data Source or External File Format objects, objects of those types should now correctly be included in the transfer.
  • Registered Servers:
    • Enabled multiserver query for UA servers (it will try to use the same token for every UA server in the group).
  • AD Universal Authentication:
    • Fixed issue where Azure AD authentication was not supported.
    • Fixed issue where table/view designer was not working.
    • Fixed issue where "Select Top 1000 rows" and "Edit Top 200 rows" were not working.
  • Database restore: fixed an issue where restore omits the last folder in the path when moving files to an alternate location.
  • Compress wizard:
  • Showplan:
    • Fixed issue where PDW operators were not recognized.
  • Server Properties:
    • Fixed issue with not being able to modify server processor affinity.

Analysis Services (AS)

  • Fixed a number of issues with Deployment Wizard to support tabular 1400 compat-level models and Power Query data sources.
  • Deployment Wizard can now deploy to AS Azure when running from Command line.
  • When using Windows Auth in AS Azure the user will now see the name of the user account in Object Explorer correctly.

Known issues in this 17.3 release:

General SSMS

  • The following SSMS functionality is not supported for Azure AD auth using UA with MFA:
    • Database Engine Tuning Advisor is not supported for Azure AD auth; there is a known issue where the error message presented to the user is a bit cryptic "Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,…" instead of the expected "Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient)".
  • Trying to analyze a query in DTA results in an error: "Object must implement IConvertible. (mscorlib)".
  • Regressed Queries is missing from the Query Store list of reports in Object Explorer.
    • Workaround: Right-click the Query Store node and select View Regressed Queries.

Integration Services (IS)

  • The [execution_path] in [catalog].[event_messagea] is not correct for package executions in Scale Out. The [execution_path] starts with “\Package” instead of the object name of the package executable. When viewing the overview report of package executions in SSMS, the link of “Execution Path” in Execution Overview cannot work. The workaround is to click “View Messages” on overview report to check all event messages.

Previous SSMS releases

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

download SSMS 17.2

Generally available | Build number: 14.0.17177.0

Enhancements

  • Multi-Factor Authentication (MFA)
    • Multiple-user Azure AD authentication for Universal authentication with Multi-factor authentication (UA with MFA)
    • A new user credential input field was added for Universal Authentication with MFA to support multi-user authentication.
  • The connection dialog box now supports the following 5 authentication methods:

    • Windows Authentication
    • SQL Server Authentication
    • Active Directory - Universal with MFA support
    • Active Directory - Password
    • Active Directory - Integrated
  • Database export/import for DacFx wizard using Universal Authentication with MFA.

  • For API support, see IUniversalAuthProvider Interface.
  • ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to 3.13.9 version.
  • In addition a new CLI interface was delivered supporting Azure AD admin setting for SQL Database and SQL Data Warehouse.

    For more information on the Active Directory authentication methods, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA) and Configure Azure SQL Database multi-factor authentication for SQL Server Management Studio.

  • Output window has entries for queries run during expansion of Object Explorer nodes

  • Enabled View designer Azure SQL Databases
  • The default scripting options for scripting objects from Object Explorer in SSMS have changed:

    • Previously, the default on a new install was to have the generated script target the latest version of SQL Server (currently SQL Server 2017).
    • In SSMS 17.2 a new option has been added: Match Script Settings to Source. When set to True, the generated script targets the same version, engine type, and engine edition as the server the object being scripted is from.
    • The Match Script Settings to Source value is set to True by default, so new installs of SSMS will automatically default to always scripting objects to the same target as the original server.
    • When the Match Script Settings to Source value is set to False, the normal scripting target options will be enabled and function as they did previously.
      • Additionally, all the scripting options have been moved to their own section - Version Options. They are no longer under General Scripting Options.
  • Added support for National Clouds in "Restore from URL"

  • QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats.
  • IntelliSense is now supported for Azure SQL Database
  • Security: connection dialog will default to not trusting server certificates and to requesting encryption for Azure SQL DB connections
  • General improvements around support for SQL Server on Linux:
    • Database Mail node is back
    • Addressed misc issues related to paths
    • Activity Monitor is more stable
    • Connection Properties dialog displays correct platform
  • Performance Dashboard server report now available as a default report:
    • Can connect to SQL Server 2008 and newer versions.
    • Missing indexes sub-report uses scoring to assist in identifying most useful indexes.
    • Historical wait stats sub-report now aggregates waits be category. Idle and sleep waits filtered out by default.
    • New Historical latches sub-report.
  • Showplan node search allows searching in plan properties. Easily look for any operator property such as table name. To use this option when viewing a plan:
    • Right-click on plan, and in the context menu click on Find Node option
    • Use CTRL+F

Analysis Services (AS)

  • New AAD role member selection for users without email addresses in AS Azure models in SSMS

Integration Services (IS)

  • Added new column ("Executed Count") to the execution report for SSIS

Known issues in this release:

  • Query windows using "Active Directory - Universal with MFA Support" authentication may experience an error similar to the following, when attempting to execute a query after being open for one hour:

    Msg 0, Level 11, State 0, Line 0 The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

    Re-running the query should get past the error and succeed.

  • The following SSMS functionality is not supported for Azure AD auth using Universal Authentication with MFA:

    • The New Table/View designer shows the old-style login prompt, and does not work for Azure AD authentication.
    • The Edit Top 200 Rows feature doesn't support Azure Ad authentication.
    • The Registered Server component does not support Azure AD authentication.
    • The Database Engine Tuning Advisor is not supported for Azure AD authentication. There is a known issue where the error message presented to the user is less than helpful: Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,… instead of the expected Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).

Analysis Services (AS)

  • Object Explorer in SSAS will not show the Windows Auth username in AS Azure connection properties.

Bug fixes

Analysis Services (AS)

  • Fixed an issue where AS Restore Database would fail with an error if the DB had a different Name than ID
  • Fixed an issue causing the DAX query window to disregard the menu option for toggling IntelliSense Enabled
  • Fixed an issue that prevented connecting to SSAS through msmdpump IIS http/https addresses
  • Allow connecting to AS Azure using a password that contain a semi-colon
  • Scripting out AS Restore Database command with "Skip Membership" option will include the new corresponding JSON option when used with SQL Server 2017 AS server or AS Azure
  • Fixed an extremely rare issue that could cause the delete database dialog to raise an error when loading
  • Fixed an issue that may occur when attempting to view partitions in 1400-compat level model containing a mix of SQL query and M partition definitions

Integration Services (IS)

  • Fixed issue where the execution information reports of SSISDB catalog can't be displayed
  • Addressed issues in SSMS related to poor performance with large number of projects/packages

download SSMS 17.1

Generally available | Build number: 14.0.17119.0

Enhancements

  • Profiler: Help > About now displays release version number (e.g 17.1)
  • Analysis Service users can refresh credentials for their datasources for 1200 TM models and above from the context menu on the datasource
  • Built-in SSIS reports now show logs from SSIS scale-out execution in CTP 2.1
  • SSIS scale-out management application
    • View basic information about scale-out master.
    • Easily add a Worker to the scale-out deployment.
    • View all the scale-out workers and basic information about them, and can also enable or disable them easily.

Bug fixes

  • Always On:
    • Fixed an issue where the properties of an Availability Replica was always displayed as "Automatic failover" mode for WSFC AGs.
    • Fixed an issue where the read-only routing list was overwritten when updating the Availability Group
  • Always Encrypted: fixed an issue where log file generated was missing the information generated by DacFx.
  • ShowPlan: fixed in issue where the UI was always showing the Actual join type attribute for non Adaptive join operators.
  • Setup:
    • Fixed an issue where SSMS 17.0 was breaking SSDT on Visual Studio 2013 [Connect Item 3133479]
    • Fixed an issue where clicking on "Restart" at the end of setup was not restarting the machine
  • Scripting: temporarily preventing SSMS from accidentally deleting Azure database objects when trying to script the deletion by disabling that option. Proper fix will be in an upcoming release of SSMS.
  • Object Explorer: fixed an issue where "Databases" node was not expanded when connected to an Azure database created using "AS COPY"

download SSMS 17.0

Generally available | Build number: 14.0.17099.0

Enhancements

  • Upgrade package and Windows Software Update Services (WSUS)
    • Future 17.X releases include a smaller cumulative update package
      • The update package will also be published to the WSUS catalog
  • Icon Updates
    • Icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions
    • New SSMS and Profiler program icons to differentiate between 16.X and 17.X versions
  • SQL PowerShell Module
    • SQL Server PowerShell module removed from SSMS and now ships via the PowerShell gallery (PowerShell 5.0 now required to support module versioning)
    • Miscellaneous improvements to the "presentation" (formatting) of some SMO objects (e.g. databases now show the size and the available space and tables show row count and space usage)
    • Added colorization when the PowerShell command prompt is invoked from the "Start PowerShell" menu in OE
    • Added -ClusterType and -RequiredCopiesToCommit parameter to AG cmdlets (New-SqlAvailabilityGroup, Join-SqlAvailabilityGroup, and Set-SqlAvailabilityGroup cmdlets)
    • Added parameters -ActiveDirectoryAuthority and -AzureKeyVaultResourceId to Add-SqlAzureAuthenticationContext cmdlet
    • Added Revoke-SqlAvailabilityGroupCreateAnyDatabase, Grant-SqlAvailabilityGroupCreateAnyDatabase and Set-SqlAvailabilityReplicaRoleToSecondary cmdlets
    • Added -SeedingMode parameter to Set-SqlAvailabilityReplica and New-SqlAvailabilityReplica cmdlets
    • Added -ConnectionString parameter to Get-SqlDatabase
  • SQL Server on Linux
    • General improvements and fixes for Log Shipping
      • Added support for native Linux paths Attach, Restore and Backup database
      • Added support for native Linux paths for audit log destination folder
  • Analysis Services
    • DAX Query Window:
      • Parentheses matching in the editor
      • DEFINE MEASURE and DEFINE VAR syntax support
      • Assorted Intellisense improvements
    • Universal Authentication
      • Allows users to specify a username and no password and the Azure Login Dialog will handle the connection
    • SSMS PQ Integration:
      • Scripting of structured data sources works
      • Viewing and Editing of structured data sources in PQ UI
  • New "Add Unique Constraint" template
  • Showplan
    • Show max instead of sum across the threads in properties window for elapsed time
    • Expose new mem grant operator properties
    • Enabled the "Edit Query" button in Live Query Statistics
    • Support for interleaved execution
      • New option to "Analyze Actual Execution Plan"
      • General improvements to showplan compare
      • Introduced functionality in Showplan Comparison feature to find significant differences in Cardinality Estimation between matching nodes of two query plans and perform basic analysis of the possible root causes
  • Removed Configuration Manager from Registered Servers explorer
  • Enable reading audit logs from Azure blob storage
  • Added Parameterization for Always Encrypted, please refer to this page for more details
  • AAD Universal auth connection to Azure SQL DB supports custom tenant id
  • Generate scripts for Azure SQL Database, now scripts full text, rules, and database
  • Branding fixes in splash screens for SSMS and Profiler
  • Removed Utility Control Point UI from SSMS
  • SSMS can now create "PremiumRS" edition SQL Azure databases
  • Always On Availability Groups
    • Add support for new cluster types: EXTERNAL and NONE
      • Add support for SQL Server on Linux
      • Add automatic seeding as an option for initial data synchronization
      • Fixed the some defects, e.g. endpoint URL handling, DB refresh and UI layout
      • Removed Azure replica related features
    • Improved IntelliSense for several Availability Group keywords
  • Activity Monitor
    • Added new "Activity Monitor" pane to the SSMS Output window
    • Changed connection error/timeout message to log info to output window rather than a pop up message
    • Removed empty chart (5th chart) in Overview section
    • Added "(paused)" to Overview title if the Activity Monitor data collection is paused
    • Graph Extensions to SQL Server
      • New icons for graph node and edge tables
      • Graph node and edge tables will be displayed under Graph Tables folder
      • Templates to create graph node and edge tables available
  • Presentation Mode
    • 3 new tasks available via Quick Launch (Ctr-Q)
    • PresentOn - Turn on presentation mode
    • PresentEdit - Edit the presentation font sizes for presentation mode. "Text Editor font" for the Query Editor. "Environment font" for other components.
    • RestoreDefaultFonts - Revert back to default settings.
    • Note: there is currently no PresentOff command at this time. Use RestoreDefaultFonts to turn off Presentation Mode

Bug fixes

  • Fixed an issue where SSMS crashed when showplan scrolled via surfacebook touchpad
  • Fixed an issue where SSMS hangs for a long times while getting the properties of a databases which is being restored or offline
  • Fixed an issue where "Help viewer" could not be opened in RC builds
  • Fixed an issue where "Maintenance Plans Tasks Toolbox" items may be missing in SSMS.
  • Fixed an issue in SSMS where the user was unable to shrink a database when the database name contained curly braces. Connect Item
  • Fixed an issue where SSMS was trying to script the deletion of an Azure database was actually causing the deletion of the database itself. Connect Item
  • Fixed an issue where default values were not scripted for user defined table types. Connect Item
  • Another round of perf improvements around context menu on indexes. Connect Item
  • Fixed issue which was causing excessive flickering when hovering mouse over missing index in execution plan. Connect Item
  • Fixed an issue where SSMS was taking the DB offline when scripting Connect Item
  • Miscellaneous UI fixes on localized (non-English) versions of SSMS.
  • Fixed issue where "Always Encrypted Keys" node was missing when targeting SQL 2016 SP1 Standard Edition.
  • Always Encrypted
    • "Always Encrypted" menu was incorrectly enabled when targeting SQL 2016 RTM Standard Edition or any SQL 2014 (and below) servers
    • Fixed an issue where IntelliSense is reporting an error when the CREATE OR ALTER syntax is used
    • Fixed issue where encryption fails in case CMK/CEK contain characters that should be escaped, i.e. enclosed in brackets
    • When an Out of Memory exception occurs in SSMS, the user is presented an error that suggests to use the native (64bit) PowerShell instead.
    • Fixed issue where the AE wizard was failing in case the user was using Resource Group Manager subscriptions instead of Classic Azure subscriptions
    • Fixed issue where AE wizard was showing an incorrect error when the user had no permissions in any subscriptions or had no Azure Key Vaults in any of them.
    • Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions in case of multiple AAD
    • Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions for which the user has reader permission
      • Fixed an issue where resource files may not be loaded correctly, thus resulting in inaccurate error messages
  • Improved contrast of hyperlinks on SSMS Setup page
  • Fixed an issue where Polybase nodes were not displayed when connected to SQL Server Express (2016 SP1)
  • Fixed an issue where SSMS is unable to change the Compatibility Level of an Azure DB to v140
  • Improved performance of Object Explorer when expanding the list of Azure databases Connect Item
  • Fixed an issue where "View SQL Server Log" context menu item appeared incorrectly for non-relational server types (AS\RS\IS)
  • Fixed an issue where checking syntax of an Analysis Services partition query using SQL auth could result in login failed message
  • Fixed an issue where renaming a preview 1400 compat-level AS tabular model would fail in SSMS
  • Fixed an “operation failed on model” issue that could occur after attempting an invalid operation on the AS server in rare circumstances, revert local changes after unsuccessful save on the model
  • Fixed a typo in Analysis Services Synchronize Database popup dialog
  • Backup/restore container dialogs come up offscreen on multiple monitor setups.
  • SecurityPolicy create fails if target object has ] in its name.
  • SSMS 2016 "Open recent" menu doesn't show recently saved files. Connect Item
  • Removed reset of user settings when VS Shell is updated.
  • Fixed an issue that was preventing the user from being able to change Compatibility Level of a database on SQL Server 2017.
  • Query windows using AAD Universal authentication cannot refresh the query after an hour.
  • Utility Control Point UI removed from SSMS.
  • AD Universal auth connections fail to query data after the initial token expiration.
  • Unable to script Rules from Azure SQL DB to Azure SQL DB.
  • Fixed issue were SQL PowerShell was not able to connect legacy SQL instances (2014 and older). Connect Item
  • Fixed an issue that was causing SSMS to crash when failing to import registered servers.
  • Fixed an issue that was causing SSMS to crash if a user has certain permissions an a database.
  • SSMS - tables disappear from design surface while reviewing views. Connect Item
  • The table scrollbar does not allow the user to scroll the table content, only the up/down Arrow allow this. Its also possible to scroll the table content after trying to scroll using the scrollbar which is a bug. Connect Item
  • Registered Servers not displaying icons after refreshing the root node.
  • Script button for Create Database on Azure v12 servers executes script then displays message "No action to be scripted".
  • SSMS Connect to Server dialog does not clear "Additional Properties" tab for each new connection.
  • Generate Tasks script doesn't generate Create Database scripts for an Azure SQL DB.
  • Scrollbar in View Designer appears disabled.
  • Always Encrypted AVK key paths do not include version ids.
  • Reduced number of engine edition queries in the query window. Connect Item
  • Always Encrypted errors from refreshing modules after encryption are incorrectly handled.
  • Changed default connection timeout for OLTP and OLAP from 15 to 30 seconds to fix a class of ignored connection failures.
  • Fixed a crash in SSMS when custom report is launched. Connect Item
  • Fixed an issue where "Generate Script…" fails for Azure SQL databases.
  • Fix "Script As" and "Generate Script Wizard" to not add extra newlines when scripting objects such as stored procedures. Connect Item
  • SQLAS PowerShell Provider: Add LastProcessed property to Dimension and MeasureGroup folders. Connect Item
  • Live Query Statistics: fixed issue where it was only showing the first query in a batch. Connect Item
  • Showplan: show max instead of sum across the threads in properties window.
  • Query Store: add new report on queries with high execution variation.
  • Object explorer performance issues: Connect Item
    • Context menu for tables momentarily hangs
    • SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection).
    • Avoid issuing table queries that sort on the server
  • Removed Azure Deployment Wizard (Deploy Database to Azure VM) from SSMS
  • Fixed issue where missing indexes were not shown in execution plans in SSMS Connect Item
  • Fixed common crash-on-shutdown issue in SSMS
  • Fixed issue in Object Explorer where an error occurred when bringing up the context menu on the Polybase|Scale-Out Group nodes Connect Item
  • Fixed an issue where SSMS may crash when trying to display the permissions on a database
  • Query Store: general enhancements in context menu items for result grids of query store report
  • Configuring Always Encrypted for an existing table fails with errors on unrelated objects. Connect Item
  • Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect Item
  • The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect Item
  • When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.
  • Fixed UI truncation issue on "New Server Registration" dialog
  • Fix DMF Condition UI incorrectly updating expressions that contain string constant values with quotes in them
  • Fixed an issue that may cause SSMS to crash when running custom reports
  • Add “Execution in Scale Out…” menu item to the folder node
  • Fixed an issue with Azure SQL DB firewall whitelist IP address feature
  • Fixed an issue in SSMS which caused an Object reference not set exception when editing the source of AS multi-dimensional partition
  • Fixed an issue in SSMS which caused an Object reference not set exception when deleting a customer assembly from multi-dimensional AS server
  • Fixed an issue where renaming an AS tabular 1400 db failed
  • Fixed an issue with scripting a 1400 compat-level AS tabular datasource from connection properties dialog
  • Remove assumption that tables in AS 1400 compat-level model have at least one partition
  • Ctrl-R now toggles results pane in SSMS DAX query editor

download SSMS 16.5.3

Generally available | Build number: 13.0.16106.4

The following issues were fixed this release:

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

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

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

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

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

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

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

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

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

  • Context menu for tables momentarily hangs

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

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

SSMS 16.5.1

Generally available | Build number: 13.0.16100.1

  • Fixed an issue where Invoke-Sqlcmd erroneously inserts multiple rows when check constraint occurs. Microsoft Connect Item: 811560

  • Fixed an issue where non-ENU language versions do not work completely when creating Availability Groups.

  • Fixed an issue where clicking query plan XML does not open the proper SSMS UI.

download SSMS 16.5

Generally available | Build number: 13.0.16000.28

  • Fixed an issue where a crash could occur when a database with table name containing “;:” was clicked on.
  • Fixed an issue where changes made to the Model page in AS Tabular Database Properties window would script out the original definition. Microsoft Connect Item: 3080744
  • Fixed the issue that temporary files are added to the “Recent Files” list.
    Microsoft Connect Item: 2558789
  • Fixed the issue that “Manage Compression” menu item is disabled for the user table nodes in object explorer tree.
    Microsoft Connect Item: 3104616

  • Fixed the issue that user is not able to set the font size for object explorer, registered server explorer, template explorer as well as object explorer details. Font for the explorers will be using the Environment font.
    Microsoft Connect Item: 691432

  • Fixed the issue that SSMS always reconnect to the default database when connection is lost.
    Microsoft Connect Item: 3102337

  • Fixed many of high dpi issues in policy management and query editor window including the execution plan icons.

  • Fixed the issue that option to config font and color for Extended Event is missing.

  • Fixed the issue of SSMS crashes that occur when closing the application or when it is trying to show the error dialog.

download SSMS 16.4.1 (September 2016)

Generally available | Build number: 13.0.15900.1

download SSMS 16.3 (August 2016)

Generally available | Version number: 13.0.15700.28


download SSMS July 2016 hotfix update

Generally available | Version number: 13.0.15600.2


SSMS July 2016

Generally available | Version number: 13.0.15500.91

  • Edit, July 5: Improved support for SQL Server 2016 (1200 compatibility level) tabular databases in the Analysis Services Process dialog and the Analysis Services deployment wizard.

  • Edit, July 5: New option in SSMS 'query execution options' dialog to set 'XACT_ABORT'. This option is enabled by default in this release of SSMS and instructs SQL Server to roll back the entire transaction and abort the batch if a run-time error occurs.

  • Support for Azure SQL Data Warehouse in SSMS.

  • Significant updates to the SQL Server PowerShell module. This includes a new SQL PowerShell module and new CMDLETs for Always Encrypted, SQL Agent, and SQL Error Logs.

  • Support for PowerShell script generation in the Always Encrypted wizard.

  • Significantly improved connection times to Azure SQL databases.

  • New "Backup to URL" dialog to support the creation of Azure storage credentials for SQL Server 2016 database backups. This dialog provides a more streamlined experience for storing database backups in an Azure storage account.

  • New Restore dialog to streamline restoring a SQL Server 2016 database backup from the Microsoft Azure storage service.

  • Bug fix in SSMS query designer to allow adding tables to the designer if a user doesn’t have SELECT permissions on them.

  • Bug fix to add IntelliSense support for 'TRY_CAST()', and 'TRY_CONVERT()' functions.
    Linked customer bug requests:
    Microsoft Connect item #2453461.

  • Bug fix in PowerShell module to enable loading of ‘SQLAS’ Analysis Services extension.
    Linked customer bug requests:
    Microsoft Connect item #2544902.

  • Bug fix in the SSMS editor window to allow drag-and-drop open of Sql files.
    Linked customer bug requests:
    Microsoft Connect item #2690658.

  • Bug fix in Profiler to fix Profiler crash when exiting.
    Linked customer bug requests:
    Microsoft Connect item #2616550.
    Microsoft Connect item #2319968.

  • Bug fix in SSMS to prevent crash when trying to edit a join link in the SSMS table designer.
    Linked customer bug requests:
    Microsoft Connect item #2721052.

  • Bug fix in SSMS to enable database script generation for db_owner role members.
    Linked customer bug requests:
    Microsoft Connect item #2869241.

  • Bug fix in SSMS editor to remove the delay in closing a query tab if the server has gone offline.
    Linked customer bug requests:
    Microsoft Connect item #2656058.

  • Bug fix to enable Backup option in SQL Server Express databases. Linked customer bug requests:
    Microsoft Connect item #2801910.
    Microsoft Connect item #2874434.

  • Bug fix in Analysis Services to correctly show the Data Feed provider for multi-dimensional Analysis Services models.


download SSMS June 2016

Generally available | Version number: 13.0.15000.23

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, see Download SQL Server Management Studio (SSMS).