Sql management studio version 13.0 download

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. Fixed in issue where importing a bacpac into SQL Express may fail.

Addressed issue where there is no option available in SSMS to rebuild a clustered columnstore index online. Fixed the logic to page the user to a proper page in most error dialogs originating from exception at the SQLClient driver level.

Fixed errors that may show up while resetting settings. Also, added back the "PresentOff " functionality, which resets the UI to its regular size. Fixed the logic that prevents the creation of a clustered columnstore index, which was overly restrictive for newer versions of SQL Server. The error message was misleading in asserting that the connection was not successful, when indeed it was. Previous known issue "Remote connections to Integration services may fail with "The specified service does not exist as an installed service.

Addressed an issue where on some locales e. Fixed an issue where an error message like "User does not have enough permissions. Fixed script generation for DW databases where it only worked if the object explorer was connected to logical master instead of the user database.

This is believe to be the cause for some sporadic issues when SSMS is started after an upgrade see known issue session for AS. Fixed capability to filter Extended Events using the event name instead of ID. Originally added in SSMS Column names are omitted from suggestions and error indicators are falsely displayed under the column names.

See the configuration documentation for more information. 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. Mitigated an issue that was causing SSMS to leak handles and memory when displaying results of queries. Fixed a long outstanding issue where the reordering of XML columns in the "Result Grid" was not working.

Fixed issue where SSMS was incorrectly displaying a warning about "change tracking not being supported for a database with memory optimized objects ". Fixed a bug inhibiting enumeration of database objects on SQL Server and older.

Fixed an issue where SQL Replication Monitor was not honoring the autoconnect settings, thus forcing the user to manually reconnect every time.

Reverted the improvement from This change is temporary and the improvement will return in a subsequent release without the accompanying bug. Remote connections to Integration services may fail with "The specified service does not exist as an installed service. The wizard fails when attempting to enumerate database objects on SQL Server and older.

Releases of SSMS before Fixed tab ordering of buttons in the "The following settings are not supported by the database" window that pops up when querying against DW. Fixed an issue where Activity Monitor was pausing when opening the "Processes" tab. Fixed an issue that may have resulted in an error when trying to connect to SSAS via msmdpump.

Fixed an issue that was causing mirror configuration to fail. 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.

Fixed the default service tier to be Standard S0 when importing a bacpac same as Azure portal and SqlPackage. Fixed an issue where intellisense doesn't work when the user is connected to an Availability Group configured for Read-Only Routing. Fixed an issue where on the Performance Dashboard you try to navigate to sublinks such as Expensive Queries and it doesn't work.

Fixed log in XEvent Viewer where the tooltip was not displaying correctly text containing text encoded using surrogate pairs. Added support for Fixed Width files and file type detection for.

Added handling for query execution to update the narrator requires NetFx4. Fixed an issue viewing Analysis Services partitions that may have caused an unhandled exception. 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 With this fix, SSMS Fixed an issue where the column name does not show in the recommendation panel of the data classification pane.

Fixed an issue on the Statistic Properties dialog where selecting the Update statistics for these columns checkbox and selecting OK yields no effect. Statistics are not updated, and trying to script the action yields a There is no action to be scripted message. Addressed issues related to CVE Fixed an issue where the SSMS was throwing an error when importing a bacpac file. Addressed an issue where SSMS can't expand databases node for master in Azure if there's a control plane outage affecting sys.

Fixed long outstanding issue introduced in SSMS Fixed an issue where an error would occur trying to open the Synchronize Database Wizard of an Analysis Services server. Fixed an issue preventing users from querying SSAS and earlier versions with cell data permissions. There is a known bug with Diagram Design that causes your existing diagrams to get corrupted.

Added a button to the VA scan result view, in order to remediate data classification rule by going to the data classification pane.

For more details, go to GitHub. Stretch database wizard: fixed an issue where the screen reader does not inform about the name of the query table when providing information about the table. Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint. 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. 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.

Fixed an issue where the Data Classification wizard won't open for databases with large number of tables. Correcting the previous validation tests adding rank, removing the illegal property InformationTypes and adding new ones for the first two points. The button just above the classified columns table now minimizes the recommendations panel, as it says. Fixed New External Table Fixed database properties, connection properties, hiding reports and rename for Azure Synapse Analytics serverless SQL pool.

Always Encrypted: Fixed an issue where the key name dropdown becomes read-only on selecting new enclave enabled key. Fixed an issue where the scroll bar started from middle in "Database Properties Options" grid. Fixed an issue that was causing SSMS to crash when opening. Connection Dialog: fixed an issue where unchecking the "Remember Password" does not work. Fixed issue where occasionally Editor windows was not properly refreshed. Fixed an issue where the controls on the Index properties could be incorrectly rendered buttons overlapping grid.

Fixed multiple issues in Database Properties dialog, which might show clipped controls on 4K monitors. Updated Flat File Import Wizard to allow check all for the allow null column. Fixed an issue where Object Explorer could display incorrect information when connection strings are used to connect in Connection Dialog. 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. 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.

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. Reversed the position of the "Next" and "Previous" buttons on the Job Step page to put them in a logical order. Also, fixed the scripting of such extended properties. Fixed an issue here items in the grid where being selected on hovering. This is for international separators, decimal, and whitespace.

Fixed a long outstanding issue where SSMS wasn't honoring the connection info passed at the command line when SQL files were also specified. 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.

Fixed an issue where Import Flat File functionality not handling text qualifiers correctly. Fixing an issue introduced in SSMS 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. 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.

SSMS very slow in the database restore dialogs. Restoring database is slow. Fixed an issue where the default language for all logins was shown as Arabic. 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. Fixing an issue in XEvent UI where hovering over the grid was causing rows to be selected. 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.

SetDefaultInitFields true was being used. Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index.

Added a Completion time in the messages to track when a given query completed its execution. Allow more data to be displayed Result to Text and stored in cells Result to Grid.

This also addressed the issue of users not able to grab more than chars from the cells of the grid. 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 Fixed an issue where the user was unable to horizontal scroll Results pane via mouse wheel.

Fixed an issue where Import Flat File Wizard was reporting a duplicate or invalid column on a. Fixed an issue where renaming databases was causing incorrect database names to show up in 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.

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. Fixed an issue in Disk Usage reports where the report was failing to when data files had a vast number of extents.

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. 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. See stackoverflow for more details. This could have been an issue in some abnormal situations, like an aborted setup or an incorrect uninstall of a previous version of SSMS.

Database diagrams were added back into SSMS. 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.

Fixed an issue in the Login properties page where clicking on the Add Credential button could throw a Null Reference Exception. Fixed layout of New Job Schedule page. 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. 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. Fixed the issue that was causing SSMS setup to fail when the setup log path contained spaces.

Fixed an issue where SSMS was exiting immediately after showing the splash screen. Fixed an issue where the Disabled menu item was still enabled, even after disabling a given Index. Removed constraint on sensitivity classification when scripting columns with Data classification. Fixed an issue where "Generate Script" on a graph table fails when generating data. Fixed an issue in UIConnectionInfo. LoadFromStream where the AdvancedOptions section wasn't read when a password wasn't specified.

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. This option is available from both the command line useful for unattended installation and the setup UI. This does not mean that SSMS is multi-instance. The block on mixed languages setup has been lifted.

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. We upgraded our minimum requirement from NetFx4. When SSMS 18 is started for the first time, the user is prompted to migrate the The user setting files are now stored as a plain XML file, thus improving portability and possibly allowing editing. SSMS isn't supported on Windows 8. Windows 10 and Windows Server require version Due to the new dependency on NetFx 4.

SSMS setup blocks those systems. Windows 8. Path to SSMS. The current release of SSMS supports the following bit platforms when used with the latest available service pack:.

SSMS is available only as a bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. For details, see Azure Data Studio. Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page. Skip to main content.

This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Tip If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please select Read in English at the top of this page.

Submit and view feedback for This product This page. View all page feedback.