Just do the same thing you would have to do in a stored proc. Wrap the
statement in a begin tran and commit. instead of putting a go at the end.

Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One




Ken Nickels <[Email Address Removed] 01:37 PM

To
"LazyDBA.com Discussion" <[Email Address Removed] true lazy question






What do you all do when you put Isql scripts with "go" statements into the
Agent job scheduler. It usually compains about this.

Thanks

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

MS Sql Server LazyDBA home page