SQL Server Management Studio
SSMS 22 showing a query, the results of the query (as a table), the Object Explorer andGithub Copilot panes while connected to a SQL Server database engine instance. The interface is demonstrated indark mode.
Developer	Microsoft
Initial release	2005
Stable release	22.3.0[1] / February 10, 2026; 8 days ago (2026-02-10)
Operating system	Microsoft Windows
Available in	Chinese (Simplified), Chinese (Traditional), Czech, English (United States), French, German, Italian, Japanese, Korean, Polish, Portuguese (Brazil), Russian, Spanish, Turkish
Website	learn.microsoft.com/ssms/sql-server-management-studio-ssms

Microsoft SQL Server Management Studio (SSMS) is a software application developed byMicrosoft that is used for configuring, managing, and administering all components withinMicrosoft SQL Server. First launched with Microsoft SQL Server 2005, it is the successor to theEnterprise Manager in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.^[2]

A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.^[3] It also shipped a separate Express edition that could be freely downloaded; however recent versions of SSMS are fully capable of connecting to and manage any SQL Server Express instance. Microsoft also incorporated backwards compatibility for older versions of SQL Server thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately.

Starting from version 11, the application was based on theVisual Studio 2010 shell, usingWPF for the user interface. Versions 18 and after are based on theVisual Studio 2017Isolated Shell.^[4]

In June 2015, Microsoft announced their intention to release future versions of SSMS independently of SQL Server database engine releases.^[5]

Since version 21 SSMS is based onVisual Studio 2022 and is installed using the Visual Studio Installer.^[6]

• Comparison of database administration tools
• SQL Server Management Objects

• SQL Server Management Studio (SSMS)

This article about software created, produced or developed byMicrosoft is astub. You can help Wikipedia byadding missing information.

• v
• t
• e

• Microsoft database software
• Database administration tools
• Microsoft software stubs

• Articles with short description
• Short description is different from Wikidata
• All stub articles