SQL Server Management Studio

From Wikipedia, the free encyclopedia

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.

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

[edit] References

1. ^ MSDN: Introducing SQL Server Management Studio
2. ^ MSDN: Using Object Explorer
3. ^ SQL Server Management Studio Express
4. ^ http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en

[edit] External links

• 10 things you should know about SQL Server 2005 Management Studio
• SQL Server 2005 Management Tools

This Microsoft article is a stub. You can help Wikipedia by expanding it.