SQL Server Management Studio

From Infogalactic: the planetary knowledge core
Jump to: navigation, search
SQL Server Management Studio
300px
Earlier version of Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance.
Developer(s) Microsoft
Initial release 2005
Stable release 12.0.2000.8
Operating system Microsoft Windows
Website microsoft.com/sqlserver

SQL Server Management Studio (SSMS) is a software application first launched with the 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.[1]

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.[2] It also has an "express" version that can be freely downloaded, however later 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 has been rewritten in WPF that is similar to Visual Studio 2010.

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

See also

References

  1. MSDN: Introducing SQL Server Management Studio
  2. MSDN: Using Object Explorer
  3. Lua error in package.lua at line 80: module 'strict' not found.

External links


<templatestyles src="Asbox/styles.css"></templatestyles>