SQL Server Management Studio

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Bardnet (talk | contribs) at 07:36, 9 August 2017 (v17.2 released earlier this week). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL Server Management Studio
Developer(s)Microsoft
Initial release2005
Stable release
17.2[1] / August 7, 2017; 6 years ago (2017-08-07)
Operating systemMicrosoft Windows
Websitemicrosoft.com/sqlserver

SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. 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.

Starting from version 11, the application was based on the Visual Studio 2010 shell, using WPF for the user interface.

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

See also

References

  1. ^ https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
  2. ^ MSDN: Introducing SQL Server Management Studio
  3. ^ MSDN: Using Object Explorer
  4. ^ "Announcing SQL Server Management Studio – June 2015 Release". SQL Release Services Blog. Microsoft. 24 Jun 2015. Retrieved 7 September 2015.

External links


Stub icon

This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_Server_Management_Studio&oldid=794648967"