September 14, 2011 at 9:42 am
I know that you can execute a query across multiple servers/db's via local server groups, if you type the query
Is there a way to open a SQL file and have the resulting query window be connected to a desired server group? I try to do this by opening a new blank query in the server group, then opening the SQL file, but the file's query window has no connection associated to it -- I have to cut/paste the file contents into the aforementioned blank query window, and I would prefer not to have to do that
September 14, 2011 at 10:05 am
I don't think there is a way to do this. You could make a SQLCMD batch file and use that.
September 15, 2011 at 7:59 am
If you have the local server group selected in the Registered Servers tab and then do Open File it will connect to group.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 15, 2011 at 11:28 am
That worked! Thank you!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply