Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant

Managing Servers

Servers and databases are the primary resources you manage in SQL Server Management Studio. When you select a top-level group in Registered Servers view, you can see the available server groups. If you expand the view of these groups by double-clicking the group name, you can see the subgroups or servers assigned to a particular group. Local servers are registered automatically (in most cases). If the remote server you want to manage is not shown, you will need to register it. If a local server is not shown, you will need to update the local registration information. Once you do that, you can connect to the server to work with it and then disconnect when you are finished simply by double-clicking the server entry in Registered ...