Posted by Jeff Kish on 03/23/06 21:05

hi.

I've tried to use the exec sql connect to ... in query analyzer, but could not
get it to parse.


Can someone show me how in a script, say the middle, I can connect to another
database and execute the remaining script lines there.

This way I can have a script update two separate db's at once.

Thanks
Jeff

Jeff Kish

[Back to original message]