Hi,
I know I can right-click in query editor window and choose "Connection->Change Connection", but is there any T-SQL code or system stored proc I can use to dynamically change server connection in the middle of a script?
Thanks,
Dave
The sqlcmd command prompt utility which can also be run in Query Editor in sqlcmd mode.
See SQL Server 2005 Books Online topic for script information
Using the sqlcmd Utility
http://msdn2.microsoft.com/en-us/library/ms180944.aspx
E. Using sqlcmd to execute code on multiple instances
The following code in a file shows a script that connects to two instances. Notice the GO before the connection to the second instance.
:CONNECT <server>\,<instance1>
EXEC dbo.SomeProcedure
GO
:CONNECT <server>\,<instance2>
EXEC dbo.SomeProcedure
GO
See SQL Server 2005 Books Onlinetopic
Editing SQLCMD Scripts with Query Editor
http://msdn2.microsoft.com/en-gb/library/ms174187.aspx
