O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required