Arrgh. forget the begin tran... is there an 'end pun'?

-----Original Message-----
From: Ken Nickels [mailto:[Email Address Removed] Wednesday, January 29, 2003 2:14 PM
To: LazyDBA.com Discussion
Subject: RE: A true lazy question


Thanks Lisa, I'll give it a "go" :-))

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Wednesday, January 29, 2003 1:56 PM
To: Ken Nickels
Cc: LazyDBA.com Discussion
Subject: Re: A true lazy question




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.

---------------------------------------------------------------------
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]MS Sql Server LazyDBA home page