Easy-to-use graphical management tool for managing SQL Server

SQL Server Management Studio

SQL Server Management Studio

  -  485 MB  -  Freeware
  • Latest Version

    SQL Server Management Studio 20.1 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows XP / Vista / Windows 7 / Windows 8 / Windows 10 / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    Microsoft Corporation / External Link

  • Filename

    SSMS-Setup-ENU.exe

Microsoft SQL Server Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to the Server to developers and administrators of all skill levels.  Originally introduced to the public as the part of the Microsoft SQL Server 2005, this app enabled professional users to easily manage, administer and configure all components of the Microsoft SQL Server Platform, with access to tools such script editors, graphical tools and everything needed to interact with objects and database features. The latest version of this app managed to completely integrate itself with all the features and additions that were introduced with the arrival of the SQL Server 2012, enabling users from all around the world to easily manage both their old and new database-related projects of all shapes and sizes.

Microsoft SQL Server Management Studio Express (SSMSE) is an integrated environment for accessing, configuring, managing, administering, and developing all components of the Server. The software combines a broad group of graphical tools with a number of rich script editors to provide access to SQLServer to developers and administrators of all skill levels. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

Note: Requires .NET Framework.

  • SQL Server Management Studio 20.1 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    SQL Server Management Studio 20.1 Screenshot 1
  • SQL Server Management Studio 20.1 Screenshot 2
  • SQL Server Management Studio 20.1 Screenshot 3
  • SQL Server Management Studio 20.1 Screenshot 4
  • SQL Server Management Studio 20.1 Screenshot 5

What's new in this version:

Drivers:
- Updated SSMS to use the latest driver versions for MSODBCSQL.MSI (17.10.6.1) and MSOLEDBSQL.MSI (18.7.2). The inclusion of these new versions could require users who also have older versions of the drivers to reboot after installing SSMS 20.1. For more information, review the release notes for the Microsoft ODBC driver and the Microsoft OLE DB driver.
- Updated Microsoft.Data.SqlClient version from 5.1.4 to 5.1.5

Libraries:
- Updated Server Management Objects (SMO) version to 171.31.0
- Updated Microsoft Visual C++ Redistributable version to 14.38.33135.0. The inclusion of these new versions could require users who also have older versions of the drivers to reboot after installing SSMS 20.1.

Object Explorer:
- Updated Object Explorer to display table names prefixed with schema in Graph edge constraint connections

Fixed:
Maintenance Plans:
- Resolved issue where Backup Database Task dialog closed after selecting the Files and Filegroups radio button in the dialog

SqlParser:
- Added support for DEFAULT_DATABASE option to CREATE LOGIN T-SQL syntax when using EXTERNAL PROVIDER

SqlParser:
- Added support for NATIVE_COMPILATION and SCHEMABINDING options to CREATE TRIGGER T-SQL syntax