Sql Management Studio 2014 Download

Sql Management Studio 2014 Download 64 Bit
Microsoft Sql Management Studio 2014 Download
Sql Management Studio 2014 Download 64 Bit
Sql Management Studio 2014 Download
Sql Management Studio 2014 Download Microsoft

Hi,
SQL Server and other Windows Server versions are supported via
TechNet so best to check with the Experts there.
TechNet - SQL Server
http://social.technet.microsoft.com/Forums/en/category/sqlserver
TechNet - Windows Server (Server 2008 R2 Forums are locked so
you will need to use the other forums for current support)
http://social.technet.microsoft.com/Forums/en/category/windowsserver
TechNet - Windows 10 IT Pro - Forums
https://social.technet.microsoft.com/Forums/windows/en-US/home?category=Windows10ITPro
TechNet - XP, Vista, Windows 7, and Windows 8/8.1 IT Pro
http://social.technet.microsoft.com/Forums/en/category/w7itpro,w8itpro,windowsvistaitpro,windowsxpitpro,windowsintune
TechNet- Forums
http://social.technet.microsoft.com/Forums/en/categories/
TechNet - Where is the Forum For…?
http://social.technet.microsoft.com/Forums/en/whatforum/threads
Application development and programming - MSDN - SQL Server Forums.
MSDN - SQL Forums
http://social.msdn.microsoft.com/Forums/en/category/sqlserver

SQL Server 2014 Management studio installation on Windows 10..net 3.5 SP1. However, as part of the Windows installation I already have.net 4.5.1 and 4.6. What should I do? To download.net 3.5 in addition to the current.net versions I have? Or there is some workaround? SQL Server 2014 Management Studio requires both.NET. Hi edm2, Adding to other post, the SQL Server 2008 is not supported on Windows 10. And if you want to install SQL Server 2014 Management Studio, you must apply SQL Server 2014 Service Pack 1 or a later update on windows 10.

Hope this helps.
--------------------------------------------------------------------------------------------
Rob Brown - Microsoft MVP <- profile - Windows Experience : Bicycle - Mark Twain said it right. -->

APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

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

18.0 (GA), April 2019

Download: Download SSMS 18.0 (GA)
Build number: 15.0.18118.0
Release date: April 24, 2019

The general availability (GA) release of SSMS 18.0 is available. If you need a previous version of SSMS, see previous SSMS releases.

What's new in 18.0 (GA)

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 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 18Common7IDEssms.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 will show 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 will be 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 is not 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 will block on 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) is not 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 will continue 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 was not always reliable.
General SSMS	Improved support for multi-monitor systems by making sure that more and more dialogs and windows pop up on the expected monitor.
General SSMS	Exposed the 'backup checksum default' server configuration in the new Database Settings page of the Server Properties Dialog. For details, see https://feedback.azure.com/forums/08035-sql-server/suggestions/34634974.
General SSMS	Exposed 'maximum size for error log files' under 'Configure SQL Server Error Logs'. For details, see https://feedback.azure.com/forums/908035/suggestions/33624115.
General SSMS	Added 'Migrate to Azure' under Tools menu – We have integrated Database Migration Assistant and Azure Database Migration Service to provide quick and easy access to help accelerate your migrations to Azure.
General SSMS	Added logic to prompt the user to commit open transactions when 'Change connection' is used.
Azure Data Studio integration	Added menu item to start/download Azure Data Studio.
Azure Data Studio integration	Added 'Start Azure Data Studio' menu item to Object Explorer.
Azure Data Studio integration	When right-clicking on a database node in OE, the user is presented with context menus to either run a query or create a new notebook in Azure Data Studio.
Azure SQL support	SLO/Edition/MaxSize database properties now accept custom names, making it easier to support future editions of Azure SQL databases.
Azure SQL support	Added support for recently added vCore SKUs (General Purpose and Business Critical): Gen4_24 and all the Gen5.
Azure SQL Managed Instance	Added new 'AAD logins' as a new login type in SMO and SSMS when connected to an Azure SQL Managed Instance.
Always On	Rehash RTO (estimated recovery time) and RPO (estimated data loss) in SSMS Always on Dashboard. See updated documentation at https://docs.microsoft.com/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups.
Always Encrypted	The Enable Always Encrypted checkbox in the new Always Encrypted tab in the Connect to Server dialog now provides an easy way to enable/disable Always Encrypted for a database connection.
Always Encrypted with secure enclaves	Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019 preview: A text field for specifying enclave attestation URL in the Connect to Server dialog (the new Always Encrypted tab). The new checkbox in the New Column Master Key dialog to control whether a new column master key allows enclave computations. Other Always Encrypted key management dialogs now expose the information on which column master keys allow enclave computations.
Audit Files	Changed authentication method from Storage Account Key based to Azure AD-based authentication.
Audit Files	Updated list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP.
Data Classification	Reorganized data classification task menu: added sub menu to the database tasks menu and added an option to open the report from the menu without opening the classify data window first.
Data Classification	Added new feature 'Data classification' to SMO. Column object exposes new properties: SensitivityLabelName, SensitivityLabelId, SensitivityInformationTypeName, SensitivityInformationTypeId, and IsClassified (read-only). For more information, see ADD SENSITIVITY CLASSIFICATION (Transact-SQL)
Data Classification	Added new 'Classification Report' menu item to the 'Data Classification' flyout.
Data Classification	Updated recommendations.
Database Compatibility Level Upgrade	Added a new option under > Tasks > Database Upgrade. This starts the new Query Tuning Assistant (QTA) to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level. Upgrading to the desired database compatibility level. Collecting a second pass of performance data over the same workload. Detect workload regressions, and provide tested recommendations to improve workload performance. This is close to the database upgrade process documented in query store usage scenarios, except for the last step where QTA does not rely on a previously known good state to generate recommendations.
Data-tier Application Wizard	Added support to import/export data tier application with graph tables.
Flat File Import Wizard	Added logic to notify the user that an import may have resulted in a renaming of the columns.
Integration Services (SSIS)	Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are in Azure Government cloud.
Integration Services (SSIS)	When you use SQL Agent of Azure SQL Managed Instance via SSMS, you can configure parameter and connection manager in SSIS agent job step.
Integration Services (SSIS)	When connecting to Azure SQL DB/Managed Instance, you can connect to it with default as initial db.
Integration Services (SSIS)	Added a new entry item Try SSIS in Azure Data Factory under 'Integration Services Catalogs' node, which can be used to launch the 'Integration Runtime Creation Wizard' and create 'Azure-SSIS Integration Runtime' quickly.
Integration Services (SSIS)	Added Create SSIS IR button in 'Catalog Creation Wizard', which can be used to launch the 'Integration Runtime Creation Wizard' and create 'Azure-SSIS Integration Runtime' quickly.
Integration Services (SSIS)	ISDeploymentWizard now supports SQL Auth, Azure Active Directory Integrated Auth, and Azure Active Directory Password Auth in command-line mode.
Integration Services (SSIS)	Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS Integration Runtime.
Object Scripting	Add new menu items for 'CREATE OR ALTER' when scripting objects.
Query Store	Improved usability of some reports (Overall Resource Consumptions) by adding thousands separator 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 are available. This will make actual plan look consistent with Live Query Stats plan.
ShowPlan	Modified tooltip and added comment when clicking on Edit Query Button for a ShowPlan, to indicate to user that the ShowPlan might be truncated by the SQL engine if the query is over 4000 characters.
ShowPlan	Added logic to display the 'Materializer Operator (External Select)'.
ShowPlan	Add new showplan attribute BatchModeOnRowStoreUsed to easily identify queries that are using the ' batch-mode scan on rowstores' feature. Anytime a query performs batch-mode scan on rowstores, a new attribute (BatchModeOnRowStoreUsed='true') gets added to StmtSimple element.
ShowPlan	Added Showplan Support to LocalCube RelOp for DW ROLLUP and CUBE.
ShowPlan	New LocalCube operator for the new ROLLUP and CUBE aggregation feature in Azure SQL Data Warehouse.
SMO	Extend SMO Support for Resumable Index Creation.
SMO	Added new event on SMO objects ('PropertyMissing') to help application authors to detect SMO performance issues sooner.
SMO	Exposed new DefaultBackupChecksum property on the Configuration object which maps to the 'backup checksum default' server configuration.
SMO	Exposed new ProductUpdateLevel property on the Server object, which maps to the servicing level for the version of SQL in use (for example, CU12, RTM).
SMO	Exposed new LastGoodCheckDbTime property on Database object, which maps to 'lastgoodcheckdbtime' database property. If such property is not available, a default value of 1/1/1900 12:00:00 AM will be returned.
SMO	Moved location for RegSrvr.xml file (Registered Server configuration file) to '%AppData%MicrosoftSQL Server Management Studio' (unversioned, so it can be shared across versions of SSMS).
SMO	Added 'Cloud Witness' as a new quorum type and as a new resource type.
SMO	Added support for 'Edge Constraints' in both SMO and SSMS.
SMO	Added cascade delete support to 'Edge Constraints' in both SMO and SSMS.
SMO	Added support for data classification 'read-write' permissions.
Vulnerability Assessment	Enabled Vulnerability Assessment tasks menu on Azure SQL DW.
Vulnerability Assessment	Change the set of vulnerability assessment rules that are run on Azure SQL Managed Instance servers, so that 'Vulnerability Assessment' scan results will be consistent with the ones in Azure SQL DB.
Vulnerability Assessment	'Vulnerability Assessment' now supports Azure SQL DW.
Vulnerability Assessment	Added a new exporting feature to export the vulnerability assessment scan results to Excel.
XEvent Viewer	XEvent Viewer: enabled showplan window for more XEvents.

Bug fixes in 18.0 (GA)

New item	Details
Crashes and freezes	Fixed a source of common SSMS crashes related to GDI objects.
Crashes and freezes	Fixed a common source of hangs and poor performance when selecting 'Script as Create/Update/Drop' (removed unnecessary fetches of SMO objects).
Crashes and freezes	Fixed a hang when connecting to an Azure SQL DB using MFA while ADAL traces are enabled.
Crashes and freezes	Fixed a hang (or perceived hang) in Live Query Statistics when invoked from Activity Monitor (the issue manifested when using SQL Server authentication with no 'Persist Security Info' set).
Crashes and freezes	Fixed a hang when selecting 'Reports' in Object Explorer which could manifest on high latency connections or temporary non-accessibility of the resources.
Crashes and freezes	Fixed a crash in SSSM when trying to use Central Management Server and Azure SQL servers. For details, see SMSS 17.5 application error and crash when using Central Management Server.
Crashes and freezes	Fixed a hang in Object Explorer by optimizing the way IsFullTextEnabled property is retrieved.
Crashes and freezes	Fixed a hang in 'Copy Database Wizard' by avoiding to build unnecessary queries to retrieve Database properties.
Crashes and freezes	Fixed an issue that was causing SSMS to hang/crash while editing T-SQL.
Crashes and freezes	Mitigated an issue where SSMS was becoming unresponsive when editing large T-SQL scripts.
Crashes and freezes	Fixed an issue that was causing SSMS to run out of memory when handling the big datasets returned by queries.
General SSMS	Fixed an issue there the 'ApplicationIntent' was not passed along in connections in 'Registered Servers'.
General SSMS	Fixed in issue where the 'New XEvent Session Wizard UI' form was not 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 > 2048GB) was throwing an arithmetic overflow error.
General SSMS	Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that could not found in subreports.
General SSMS	Another round of fixes to make SSMS more multi-monitor aware by having it open dialog in the correct monitor.
Analysis Services (AS)	Fixed an issue where the 'Advanced Settings' to the AS XEvent UI was clipped.
Analysis Services (AS)	Fixed an issue where DAX parsing throws file not found exception.
Azure SQL Database	Fixed an issue where the database list was not populated correctly for Azure SQL Database query window when connected to a user database in Azure SQL DB instead of to master.
Azure SQL Database	Fixed an issue where it was not 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 a 'Index was out of range. Must be non-negative and less than the size of the collection.' error when the user had no subscriptions in some tenants. The user could run into this one when trying to restore a backup from URL, for example.
Azure SQL - General Support	Fixed issue where Service Level Objectives were hardcoded, thus making it harder for SSMS to support newer Azure SQL SLOs. Now, the user can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size)
Azure SQL DB Managed Instance support	Improved/polished the support for Managed Instances: disabled unsupported options in UI and and a fix to the View Audit Logs option to handle URL audit target.
Azure SQL DB Managed Instance support	'Generate and Publish scripts' wizard scripts unsupported CREATE DATABASE clauses.
Azure SQL DB Managed Instance support	Enable Live Query Statistics for Managed Instances.
Azure SQL DB Managed Instance support	Database properties->Files was incorrectly scripting ALTER DB ADD FILE.
Azure SQL DB Managed Instance support	Fixed regression with SQL Agent scheduler where ONIDLE scheduling was chosen even when some other scheduling type was chosen.
Azure SQL DB Managed Instance support	Adjusting MAXTRANSFERRATE, MAXBLOCKSIZE for doing backups on Azure Storage.
Azure SQL DB Managed Instance support	The issue where tail log backup is scripted before RESTORE operation (this is not supported on CL).
Azure SQL DB Managed Instance support	Create database wizard not scripting correctly CREATE DATABASE statement.
Azure SQL DB Managed Instance support	Special handling of SSIS packages within SSMS when connected to Managed Instances.
Azure SQL DB Managed Instance support	Fixed an issue where an error was displayed while trying to use 'Activity Monitor' when connected to Managed Instances.
Azure SQL DB Managed Instance support	Improved support for AAD Logins (in SSMS Explorer).
Azure SQL DB Managed Instance support	Improved scripting of SMO Filegroups objects.
Azure SQL DB Managed Instance support	Improved UI for credentials.
Azure SQL DB Managed Instance support	Added support for Logical Replication.
Azure SQL DB Managed Instance support	Fixed an issue which was causing right-clicking on a database and choosing 'Import to show errors.
Azure SQL DB Managed Instance support	Fixed an issue where trying to scripting ALTER DB ADD FILE statement in SMO was causing the generated T-SQL script to be empty.
Azure SQL DB Managed Instance support	Improved display of Managed Instances server specific properties (hardware generation, service tier, storage used and reserved).
Azure SQL DB Managed Instance support	Fixed an issue where scripting of a database ('Script as Create...') was not 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 sub-optimal. 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 was not displaying secondary files that were renamed. Now, the file is displayed and a comment about it is is added (e.g. '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 was not working when connected using AAD.
Data Classification	Fixed an issue when saving classifications in the data classification pane while there are another data classification panes open on other databases.
Data-tier Application Wizard	Fixed an issue where the user was not able to import a was not handling double quotes correctly (escaping). See https://feedback.azure.com/forums/908035/suggestions/32897998.
Flat File Import Wizard	Fixed an issue where related to incorrect handling of floating-point types (on locales that use a different delimiter for floating points).
Flat File Import Wizard	Fixed an issue related to importing of bits when values are 0 or 1. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898535.
Flat File Import Wizard	Fixed an issue where floats were entered as nulls.
Flat File Import Wizard	Fixed an issue where the import wizard was not able to process negative decimal values.
Flat File Import Wizard	Fixed an issue where the wizard was not able to import from single column CSV files.
Flat File Import Wizard	will be in SSMS 17.9] Fixed issue where Flat File Import does not allow changing destination table when table is already existing. See https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186.
Help Viewer	Improved logic around honoring the online/offline modes (there may still be a few issues that need to be addressed).
Help Viewer	Fixed the 'View Help' to honor the online/offline settings. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897791.
High Availability Disaster Recovery (HADR) Availability Groups (AG)	Fixed an issue where roles in 'Fail Over Availability Groups' wizard was always displayed as 'Resolving'.
High Availability Disaster Recovery (HADR) Availability Groups (AG)	Fixed an issue where SSMS was showing truncated warnings in 'AG Dashboard'.
Integration Services (IS)	Fixed a SxS issue that deployment wizard will fail to connect to sql server when SQL Server 2019 and SSMS 18.0 are installed on the same machine.
Integration Services (IS)	Fixed an issue that maintenance plan task can’t be edited when designing the maintenance plan.
Integration Services (IS)	Fixed an issue that deployment wizard will 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 tenants.
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 was not escaping quotes before invoking the 'Edit Top N...' causing the designer to get confused.
Object Explorer	Fixed an issue where the 'ImportDatabase Mail Configuration' where the status of the SSL checkbox was not persisted. 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 (e.g. '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 was not 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 kind of tables in the current version of SSMS.
Object Explorer	Fixed an issue where the 'New Job Schedule' dialog was not 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 have default values are omitted.
Object Scripting	Don't generate dynamic T-SQL when scripting. See https://feedback.azure.com/forums/908035-sql-server/suggestions/32898391.
Object Scripting	Omit the graph syntax 'as edge' and 'as node' when scripting a table on SQL Server 2016 and earlier.
Object Scripting	Fixed an issue where scripting of database objects was failing when connecting to an Azure SQL DB using AAD with MFA.
Object Scripting	Fixed an issue where trying to script a spatial index with GEOMETRY_AUTO_GRID/GEOGRAPHY_AUTO_GRID on a Azure SQL DB was throwing an error.
Object Scripting	Fixed an issue which was causing the database scripting (of a 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 non-clustered 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 was not 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 mem grant operator properties display incorrectly when there is more than one thread.
ShowPlan	Add the following 4 attributes in RunTimeCountersPerThread of actual execution xml plan: HpcRowCount (Number of rows processed by hpc device), HpcKernelElapsedUs (elapsed time wait for kernel execution in use), HpcHostToDeviceBytes (bytes transferred from host to device), and HpcDeviceToHostBytes (bytes transferred from device to host).
ShowPlan	Fixed an issue where the similar plan nodes are highlighted in the wrong position.
SMO	Fixed an issue where SMO/ServerConnection did not SqlCredential-based connections correctly. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/33698941.
SMO	Fixed an issue where an application written using SMO would encounter an error if it tried to enumerate databases from the same server on multiple threads even though it uses separate SqlConnection instances on each thread.
SMO	Fixed performance regression in Transfer from External Tables.
SMO	Fixed issue in ServerConnection thread-safety which was causing SMO to leak SqlConnection instances when targeting Azure.
SMO	Fixed an issue which was causing a StringBuilder.FormatError when trying to restore a database which had curly braces in its name.
SMO	Fixed an issue where Azure databases in SMO were defaulting to Case-Insensitive collation for all string comparisons instead of using the specified collation for the database.
SSMS Editor	Fixed an issue where 'SQL System Table' where restoring the default colors was chancing the color to lime green, rather than the default green, making it very 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 was not working when connected to Azure SQLDW using AAD authentication.
SSMS Editor	Fixed intellisense in Azure when user lacks access to master database.
SSMS Editor	Fixed code snippets to create 'temporal tables' which were broken when the collation of the target database was case sensitive.
SSMS Editor	New TRANSLATE function now recognized by intellisense. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898430.
SSMS Editor	Improved intellisense on FORMAT built-in function. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898676.
SSMS Editor	LAG and LEAD are now recognized as built-in functions. For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898757.
SSMS Editor	Fixed an issue where intellisense was giving a warning when using 'ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)'.
SSMS Editor	Fixed an issue where several system views and table values functions were not 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 was not resizing properly.
SSMS Options	SSMS will now by default disable automatic download of DTD in XMLA editor -- XMLA script editor (which uses the xml language service) will by default now prevent automatically downloading the DTD for potentially malicious xmla files. This is controlled by turning off the “Automatically download DTDs and Schemas” setting in Tools > Options > Environment > Text Editor > XML > Miscellaneous.
SSMS Options	Restored CTRL+D to be the shortcut as it used to be in older version of SSMS. For details, see https://feedback.azure.com/forums/908035/suggestions/35544754.
Table Designer	Fixed a crash in 'Edit 200 rows'.
Table Designer	Fixed an issue where the designer was allowing to add a table when connected to an Azure SQL database.
Vulnerability Assessment	Fixed an issue where the scan results are not being loaded properly.
XEvent	Added two columns 'action_name' and 'class_type_desc' that show action id and class type fields as readable strings.
XEvent	Removed the event XEvent Viewer cap of 1,000,000 events.
XEvent Profiler	Fixed an issue where XEvent Profiler failed to launch when connected to a 96-core SQL Server.
XEvent Viewer	Fixed an issue where XEvent Viewer was crashing when trying to group the events using the 'Extended Event Toolbar Options'.

Deprecated and removed features in 18.0 (GA)

Deprecated / Removed Features

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

Previous SSMS releases

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

SSMS 17.9.1

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

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

Fixed an issue where users may experience their connection being closed and reopened with each query invocation when using '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 'ImportFlat File Wizard' dialog
Fixed issue where the wizard did not allow changing the destination table when the table already existed: this allows users to retry without having to exit the wizard, delete the failed table, and then reenter the information into the wizard (User Voice item: https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186).

Import/Export when dealing with tables with partitions defined and no indexes on the table.

Intellisense:

Fixed an issue where intellisense completion was not working when using AAD with MFA.

Object Explorer:

Fixed an issue where the 'Filter Dialog' was displayed on random monitors instead of the monitor where SSMS was running (multi-monitor systems).

Azure SQL:

Fixed an issue related to enumeration of databases in the 'Available Databases' where 'master' was not displayed in the dropdown when connected to a specific database.
Fixed an issue where trying to generate a script ('Data' or 'Schema and Data') was failing then connected to the Azure SQL Database using AAD with MFA.
Fixed an issue in the View Designer (Views) where it was not possible to select 'Add Tables' from the UI when connected to a Azure SQL Database.
Fixed an issue where SSMS Query Editor was silently closing and reopening connections during MFA token renewal. This prevents side effects unbeknownst to the user (like closing a transaction and never reopening again) from happening. The change adds the token expiration time to the properties window.
Fixed an issue where SSMS was not enforcing password prompts for imported MSA accounts for AAD with MFA login.

Activity Monitor:

Fixed an issue that was causing 'Live Query Statistics' to hang when launched from Activity Monitor and SQL Authentication was used.

Microsoft Azure integration:

Fixed an issue where SSMS only shows the first 50 subscriptions (Always Encrypted dialogs, Backup/Restore from URL dialogs, and other dialogs).
Fixed an issue where SSMS was throwing an exception ('Index out of range') while trying to sign in to a Microsoft Azure account that did not have any storage account (in Restore Backup from URL dialog).

Object Scripting:

When scripting 'Drop and Create', SSMS now avoids generating dynamic T-SQL.
When scripting a database object, SSMS now does not generate script to set database scoped configurations, if they are set to default values.

Help:

Fixed a long outstanding issue where 'Help on Help' was not honoring the online/offline mode.
When clicking on 'Help | Community Projects and Samples' SSMS now opens the default browser that points to a Git page and shows no errors/warnings due to old browser being used.

Known issues

Important

When using Active Directory - Universal with MFA Support authentication with the SQL query editor, users may experience their connection being closed and reopened with each query invocation. Side effects of such closure include global temporary tables being dropped unexpectedly and sometimes a new SPID being given to the connection. This closure will not occur if there is an open transaction on the connection. To work around this issue, users can set persist security info=true in the connection parameters.

SSMS 17.8.1

A bug was discovered in 17.8 related to provisioning SQL databases, so SSMS 17.8.1 replaces 17.8.

Build number: 14.0.17277.0
Release date: June 26, 2018

What's new

General SSMS

Database Properties:

This improvement exposes the AUTOGROW_ALL_FILES configuration option for Filegroups. This new config option is added under the Database Properties > Filegroups window in the form of a new column (Autogrow All Files) of checkboxes for each available Filegroup (except for Filestream and Memory Optimized Filegroups). The user can enable/disable AUTOGROW_ALL_FILES for a particular Filegroup by toggling the corresponding Autogrow_All_Files checkbox. Correspondingly, the AUTOGROW_ALL_FILES option is properly scripted when scripting the database for CREATE / generating scripts for the database (SQL2016 and above).

SQL Editor:

Improved experience with Intellisense in Azure SQL Database when the user doesn't have master access.

Scripting:

General performance improvements, especially over high-latency connections.

Analysis Services (AS)

Analysis Services client libraries and data providers updated to the latest version, which added support for the new Azure Government AAD authority (login.microsoftonline.us).