Free Training and Career help

In this tutorial you will learn further more about Using SQL Sever Management Studio, Registered Servers, To Register a server, Server Groups, The Summary Page, The Database Engine Administration, The tasks of a Database Administrator

Registered servers can be viewed in the Registered servers window. Servers can be created and registered, renamed or removed in the SQL Server Management Studio. Information on frequently accessed servers will be stored in the Management Studio on Registration.

Right click a node in the Registered Server’s Tree and click Update Local Server Registration. This updates the local server registration.

If a new server has to be created and registered

1. Click Database Engine in the Registered Servers tool bar

2. Right click Microsoft SQL Servers and point to New and then click Server Registration

3. In the Registration Dialog box, click on General Tab and enter the name in the Server Name text box. If it is a named instance type the name in the format server_name[\instance_name]. In this illustration we have assumed that we want to create a server named Tutorial Server.

Read More...

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