PDA

View Full Version : SQL script on multiple instance



Thiyagu
06-03-2005, 01:43 PM
Hi,
My requirement is to run same set of sql scripts on multiple instance of the SQL server DB. I know it can be done by creating multiple SQL connections and associate the files to each of the connection. I would like to know is there any other way to do it without creating multiple SQL connections?

Thank You.

hidenori
06-05-2005, 12:54 AM
You can specify multiple server names separated with semi-colons in the Server name field.

Thiyagu
06-06-2005, 12:36 PM
Thanks a lot, it works :)