Microsoft® SQL Server® 2012 Bible

87

Chapter 5: SQL Server Management and Development Tools

5

benefi t of registering a server is that it can be given an alias, or Registered Server Name, in

the Properties page, which is great if you’re a DBA managing dozens of servers or instances

with cryptic server names.

After a server is registered, you can easily select a server, and using the context menu,

connect to it with Object Explorer or Query Editor. Although this is a good thing, the

server aliases don’t propagate to the Object Explorer, which can lead to confusion. The

workaround is to keep the Object Explorer free from all other connections except those

currently in use.

You can also use the Server context menu, as shown in Figure 5-3, to connect to the server

with Object Explorer or Query Editor, or apply Policies. Other tasks include starting and

stopping the service, and opening the registration’s Properties page.

To share your registered server list, or move from one SSMS installation to another, export

and import the server confi gurations using the Context menu ➪ Tasks ➪ Import/Export.

FIGURE 5-3

Registered Servers is the tool used to manage multiple servers. Here, we see the context

menu showing how to manage service control remotely on your servers.

c05 July 23, 2012 11:44 AM V1

c05.indd 87c05.indd 87 7/30/2012 4:14:44 PM7/30/2012 4:14:44 PM

http://www.it-ebooks.info