Just to clariy

If I have a job step with

use DB1
go
sp_dropuser cgi_client
sp_dropuser client_asp

use db2
go
sp_dropuser cgi_client
sp_dropuser client_asp

you're saying I can replace it with...

Begin Tran
use db1
commit
sp_dropuser cgi_client
sp_dropuser client_asp


begin tran
use Db2
commit
sp_dropuser cgi_client
sp_dropuser client_asp


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