Wikipedia

SQL Server Management Studio

This is an old revision of this page, as edited by Mahanga (talk | contribs) at 08:46, 11 February 2009. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions 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]

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.

A central feature of SQL Server Management Studio is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.[2]

Microsoft has also introduced a graphical configuration tool called SQL Server Management Studio Express (SSMSE) for SQL Server Express. [3] As with all of Microsoft's "Express" products, this is downloadable at no charge. The tool's limitations lie in the fact that it cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, or SQL Server 2005 Mobile Edition.[4]

See also

References

  1. ^ MSDN: Introducing SQL Server Management Studio
  2. ^ MSDN: Using Object Explorer
  3. ^ SQL Server Management Studio Express
  4. ^ Download details: Microsoft SQL Server Management Studio Express
 

This article related to 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=269963634"