In Management Studio, under Registered Servers, I double-click a server name (could be sql 2000 or sql 2005 server) and it apperars in "Object Explorer" where I can work with it. I click the "Save All" button in Management Studio, exit Studio, and re-start Studio. When I do, I find that all the servers I placed under "Object Explorer" are now missing and I need to go through the "double-click the registered server" ritual again. And again, and again.
What am I doing wrong here? Why don't the servers "stick" in Object Explorer?
TIA
barkingdog
P.S. I have Sql 2005 SP1 installed on my box.
When the server is listed under Object Explorer you've got an active connection to that server. You probably don't want to open active connections to each of your servers every time you run Management Studio.
If you don't already have the window open, go to the View menu and open up the Registered Servers window. I keep that one open, and double-click a server in that window when I need to connect to perform some maintenance on the server. It pops right up in the Object Explorer window and I'm ready to work.
|||>>>When the server is listed under Object Explorer you've got an active connection to that server.
Thanks for the reply. It makes sense but I sure didn't think of it myself.
Three barks and a tail wave
Barkingdog
No comments:
Post a Comment