Free Training and Career help

In the tutorial you will learn about Using SQL Sever Management Studio, The features of the Management Studio, Starting SQL Server Management Studio, The Object Explorer and also Default. Optional connection settings.

A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical user interface called the SQL Server Management Studio. The SQL Server Management Studio combines graphical user interface with a rich script editor, so that administrators can script and administrate from a single window.

The SQL Server Management studio harnesses the power of the Enterprise manager and Query Analyzer of the earlier versions and also provides a single window to the other functionalities such as Analysis Services, Integration Services, Reporting Services and XQuery. The features of the Management Studio can be listed as under:

1. Supports administrative tasks for SQL Server 2005 and 2000.
2. Provides an integrated environment for Database Engine management and authoring
3. Provides access to SQL Server database engine, Analysis Services, Reporting Services, Notification Services, SQL Server Mobile and the script editor.
4. The dialog boxes are non modal and hence user is able to access multiple tools simultaneously.
5. The scheduling dialog box allows users schedule management tasks as per convenience.
6. Server registrations can be exported or imported from one Management Studio to another.
7. XML Showplan or Deadlock files generated by the SQL Server Profiler can be saved or printed for review.
8. The error informational message box facilitates user comments on error messages. Error messages can be copied to clipboard and emailed to the support team at Microsoft or within the organization.
9. The integrated web browser enables ease of access to MSDN and online help.
10. The Help system is also integrated with MyHelp and online communities.

Read More...

http://www.exforsys.com/content/view/1849/356/