June 25, 2008 at 10:36 am
The title just about says it all. I tend to open 8 or more connections every morning when I get in and I would rather run a script than go through all of the mouse clicks necessary in the UI. Anyone heard of a system stored procedure that can do this for us?
TIA
June 25, 2008 at 11:19 am
If I'm reading this correctly, there's an option in Management Studio to open the object browser when you open Management Studio. Does that do what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 11:27 am
GSquared (6/25/2008)
If I'm reading this correctly, there's an option in Management Studio to open the object browser when you open Management Studio. Does that do what you need?
No, I'm referring not to opening the object browser, but to actual connections to a list of instances within the object browser.
Here is the order of operations:
Double-click a server name\ctrl-C\Connect in object explorer\Database engine...\Paste Server Name\Connect.
That adds up to 9 clicks and keystrokes (if my addition is correct).
8 servers multiplied by 9 clicks is 72 clicks a day; whereas, running a script would do the same things in one keystroke: F5.
June 25, 2008 at 11:36 am
A T-SQL script runs at the server. It cannot interact with your client tools on your workstation.
You want some kind of client-side macro ability in Management Studio. There is none.
June 25, 2008 at 11:56 am
I get that you're opening 8 connections. I think I'm reading that they are to 8 different servers. Is that correct?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 12:30 pm
You can have a list of "REGISTERED" servers with the saved connection credentials and then is a matter of double-clicking each one of them. Is that what you are after ?
* Noel
June 25, 2008 at 12:54 pm
[quote-0Here is the order of operations:
Double-click a server name\ctrl-C\Connect in object explorer\Database engine...\Paste Server Name\Connect.
That adds up to 9 clicks and keystrokes (if my addition is correct).
8 servers multiplied by 9 clicks is 72 clicks a day; whereas, running a script would do the same things in one keystroke: F5.[/quote-0]
Where are you double-clicking the server name? Is this in Registered Servers? If so, it sounds like you are double-clicking to get the name of the server to copy the name, which you don't need to do. Double-clicking on the server name in Registered Servers should connect Object Explorer. I would guess that you are not double-clicking fast enough...;)
In SSMS 2008 - you will be able to right-click the group folder for your registered servers and open Object Explorer for all instances registered in that group.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 25, 2008 at 1:16 pm
That's true: I can double-click in registered servers, but I would still like to script it out in T-SQL and avoid all that clicking.
June 25, 2008 at 1:45 pm
T-SQL doesn't do that. Not what it's for.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply