What is SQL Server Management Studio?
Introduced in SQL Server 2005, SQL Server Management Studio or SSMS is an integrated environment for accessing,
configuring, managing, administering, and developing all components of SQL Server. SQL Server Management Studio
combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server
to developers and administrators of all skill levels.
SQL Server Management Studio combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager,
included in previous releases of SQL Server, into a single environment. In addition, SQL Server Management Studio
works with all components of SQL Server such as Reporting Services, Integration Services, SQL Server Compact Edition,
and Notification Services.
SQL Server Management Studio features
SQL Server Management Studio includes the following helpful features:
- Supports most administrative tasks for SQL Server 2005 and SQL Server 2000.
- A single, integrated environment for SQL Server Database Engine management and authoring.
- New management dialogs for managing objects in the SQL Server Database Engine, Analysis Services,
Reporting Services, Notification Services, and SQL Server Compact Edition, that allows you to execute
your actions immediately, send them to a Code Editor, or script them for later execution.
- Non-modal and resizable dialogs allow access to multiple tools while a dialog is open.
- A common scheduling dialog that allows you to perform action of the management dialogs at a later time.
- Exporting and importing SQL Server Management Studio server registration from one Management Studio
environment to another.
- Save or print XML Showplan or Deadlock files generated by SQL Server Profiler, review them later,
or send them to administrators for analysis.
- A new error and informational message box that presents much more information, allows you to send
Microsoft a comment about the messages, allows you to copy messages to the clipboard, and allows you
to easily e-mail the messages to your support team.
- An integrated Web browser for quick browsing of MSDN or online help.
- Integration of Help from online communities.
- A tutorial on SQL Server Management Studio to help you take advantage of the many new features and become
more productive right away. To take the tutorial, go to SQL Server Management Studio Tutorial.
- A new activity monitor with filtering and automatic refresh.
- Integrated Database Mail interfaces.
Click here to go back to the SQL Server content index page.
|