86
Part I: Laying the Foundations
FIGURE 5-2
Although Management Studio can be confi gured with multiple windows, this is a common
confi guration for doing development work: Object Explorer Details for searches and Query
Editor for script-style coding in the tabbed view, with a little Object Explorer on the side.Registered Servers
Registered Servers is an optional built-in feature; if you manage only one or a few SQL
Servers, Registered Servers offers little benefi t. If, however, you are responsible for many
SQL Servers, or if you simply want an organized way to manage your registered instances,
this is the right place to take control.Using Registered Servers, you can maintain connection information for connections to
the Database Engine, Analysis Services, Reporting Services, SQL Server Mobile Edition
Databases, and Integration Services. The toolbar at the top of Registered Services enables
selection among the types of services.Managing Servers
Servers are easily registered using the context menu and supplying the Properties page
with the server name, authentication, and maybe the connection information. One keyc05 July 23, 2012 11:44 AM V1
c05.indd 86c05.indd 86 7/30/2012 4:14:44 PM7/30/2012 4:14:44 PM
http://www.it-ebooks.info