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.

Categories: News

Related Posts

News

ITIL PREDICTIVE ANALYTICS REPORT

  This ITIL report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. The Predictive Analytics Scores below – ordered Read more…

News

Cybersecurity PREDICTIVE ANALYTICS REPORT

Read online and subscribe to Predictive Analytics Email Updates HERE You can have a say in which analytics you need in which timeframe: simply add your (anonymous) need to the list at https://theartofservice.com/predictive-analytics-topics-reports-urgency and we Read more…

News

Storage Technologies PREDICTIVE ANALYTICS REPORT

  This Storage Technologies report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. This predictive analytics evaluates 36 storage-related Read more…