Sorry

DB1..sp_dropuser cgi_client
GO
DB1..sp_dropuser client_asp
GO
Db2..sp_dropuser cgi_client
GO
Db2..sp_dropuser client_asp
GO
-----Original Message-----
From: Patrick Gallucci [mailto:[Email Address Removed]
Sent: Wednesday, January 29, 2003 2:41 PM
To: LazyDBA.com Discussion
Subject: RE: A true lazy question - and clarification



DB1..sp_dropuser cgi_client
DB1..sp_dropuser client_asp
Db2..sp_dropuser cgi_client
Db2..sp_dropuser client_asp



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




I don't think you can change databases in a job step. I would suggest
creating a step for each database that you need to execute code in.

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




Ken Nickels <[Email Address Removed] 02:50 PM

To
"LazyDBA.com Discussion" <[Email Address Removed] A true lazy question - and clarification






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] For 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] For 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] For additional
commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page