The SQL Server Management Studio is one of the tools included in the SQL Server 2005 as produced by Microsoft. It has a Graphic User Interface (GUI) tool designed for configuring, managing and administering all components within the Microsoft SQL Server.
The SQL Server Management Studio has the Object Explorer that allows user to browse, select and act upon any of the objects within the server. It is used to observe visually and analyze query plans and optimize the database performance. You can also use the SQL Server Management Studio to create a new database, change any existing database schema by adding or modifying tables and indexes, or analyze performance. It has query windows that provide a GUI based interface to write and execute queries.
The following are some of the general features of the SQL Server Management Studio:
1. It supports most of the administrative tasks for SQL Server.
2. It works on a single, integrated environment for SQL Server Database Engine management and authoring.
3. It has new management dialogs used for managing objects in the SQL Server Database Engine, Analysis Services, Reporting Services, Notification Services, and SQL Server Compact 3.5. These allow user to execute actions immediately, send them to a Code Editor, or script them for later execution.
4. It is non-modal and has resizable dialogs, which allow access to use multiple tools even while a dialog is open.
5. It has a common scheduling dialog, which allows users to perform action of the management dialogs at a later time.
6. It has new error and informational message box which provides more information and allows users to send Microsoft a comment regarding the messages. It also allows users to copy message to the clipboard, and access e-mail the messages to support team.