SQL Server Management Studio: Difference between revisions

Revision as of 12:26, 1 July 2025

Latest revision as of 17:00, 13 August 2025

(2 intermediate revisions by 2 users not shown)

Line 13:

| released = 2005

| discontinued =

| latest release version = <!-- If you update this, remember to also update [[Comparison of database tools]]-->21.34.712<ref name="ssms_release">{{cite web |url=https://learn.microsoft.com/ssms/install/install |title=Install SQL Server Management Studio |date=2025-0608-2312 |accessdate=2025-0608-2513}}</ref>

| latest release date = {{Start date and age|2025|0608|2312}}

| programming language =

| operating system = [[Microsoft Windows]]

Line 25:

}}

'''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.<ref>{{cite web|url=https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms?view=sql-server-ver16 |title=What is SQL Server Management Studio (SSMS)? |date=2022-01-28 |website=microsoft.com |accessdate=2022-07-14}}</ref>

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.<ref>{{cite web |url=https://docs.microsoft.com/en-us/sql/ssms/object/manage-objects-by-using-object-explorer?view=sql-server-ver16= |website=microsoft.com |title=Manage Objects by Using Object Explorer |date=2022-01-18 |accessdate=2022-07-14}}</ref> 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.