March 9, 2009 at 10:05 am
I want to connect to 10+ databases when I first start SQL Management Studio each day. Instead of doing "File" -> "Connect" one at a time, is there a way to put all the server names in a group and connect to them all at once ? Once I've connected, I see I can "register" the server, but I don't see what that actually does.
March 9, 2009 at 10:09 am
AFAIK, there is no built-in way to do this.
You might be able to do it with the VS-IDE Add-In trick, but that would involve some serious programming.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 11:40 am
Oy, I wish!
However, there's a minor workaround.
Register all your servers in the "Registered Servers" sidebar. Keep that pinned open so every morning, all you have to do is doubleclick on them.
It still involves doing things one by one, though, so it doesn't help by much.
March 9, 2009 at 12:37 pm
Right, Brandie. I should have also mentioned that that Registered Servers serves as a kind of shortcut-linking facility so that you do not have to type in the server's name or browse for it all the time.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 12:57 pm
I personally get annoyed at having too many connections opened. Because SQL Server 2005 SSMS (I love it) creates a query window for server/database that you have clicked on. So you might end up doing something on a database and server you didn't intend to. I think using the shortcut window and disconnecting/reconnecting is safer.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply