SQL Server Management Studio: Difference between revisions

Revision as of 19:35, 14 July 2022

Revision as of 19:37, 14 July 2022

Line 30:

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 |urlhttpsurl=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.

Starting from version 11, the application was based on the [[Microsoft Visual Studio#Visual Studio 2010|Visual Studio 2010]] shell, using [[Windows Presentation Foundation|WPF]] for the user interface. Versions 18 and after are based on the [[Microsoft Visual Studio#2017|Visual Studio 2017]] [[Microsoft Visual Studio#Extensibility|Isolated Shell]].<ref>{{cite web|title=SSMS 18.0 (preview 4)|url=https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017#ssms-180-preview-4download-sql-server-management-studio-ssmsmd|website=SQL Server Management Studio - Changelog (SSMS)|publisher=Microsoft|access-date=22 October 2018|date=24 September 2018}}</ref>