SQL Server Management Studio

"SSMS" redirects here. For the type of mass spectrometer using spark ionization, see spark source mass spectrometer.
SQL Server Management Studio
DeveloperMicrosoft
Initial release2005
Stable release
22.6.0[1] / May 12, 2026; 25 days ago (2026-05-12)
Operating systemMicrosoft Windows
Available inChinese (Simplified), Chinese (Traditional), Czech, English (United States), French, German, Italian, Japanese, Korean, Polish, Portuguese (Brazil), Russian, Spanish, Turkish
Websitelearn.microsoft.com/ssms/sql-server-management-studio-ssms

Microsoft SQL Server Management Studio (SSMS) is a software application developed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. First launched with Microsoft SQL Server 2005, it is the successor to the Enterprise 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 the Visual Studio 2010 shell, using WPF for the user interface. Versions 18 and after are based on the Visual Studio 2017 Isolated 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 on Visual Studio 2022 and is installed using the Visual Studio Installer. [6]

See also

References

  1. ^ "Release notes for SQL Server Management Studio (SSMS)". 2026-05-12. Retrieved 2026-05-25.
  2. ^ "What is SQL Server Management Studio (SSMS)?". microsoft.com. 2022-01-28. Retrieved 2022-07-14.
  3. ^ "Manage Objects by Using Object Explorer". microsoft.com. 2022-01-18. Retrieved 2022-07-14.
  4. ^ "SSMS 18.0 (preview 4)". SQL Server Management Studio - Changelog (SSMS). Microsoft. 24 September 2018. Retrieved 22 October 2018.
  5. ^ "Announcing SQL Server Management Studio – June 2015 Release". SQL Release Services Blog. Microsoft. 24 June 2015. Retrieved 7 September 2015.
  6. ^ "Release notes for SQL Server Management Studio (SSMS)". Microsoft Learn. Microsoft. 19 May 2025.
Stub icon

This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by adding missing information.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.