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

• Next in forum: Optimising queries
• Prev in forum: Help selecting the proper child record
• Thread view: connecting in a script to another db

[Reply to this message]