Why I oughtta...
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Wednesday, January 29, 2003 3:59 PM
To: LazyDBA.com Discussion
Subject: RE: A true lazy question - and clarification -Correction
try this...
begin
DB1..sp_dropuser cgi_client
end
begin
DB1..sp_dropuser client_asp
end
begin
Db2..sp_dropuser cgi_client
end
begin
Db2..sp_dropuser client_asp
end
Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One
Ken Nickels <[Email Address Removed] 03:43 PM
To
"LazyDBA.com Discussion" <[Email Address Removed] A true lazy question - and clarification -Correction
Hey now... shouldn't this sort of help be reserved for Friday afternoons?
-----Original Message-----
From: Patrick Gallucci [mailto:[Email Address Removed] Wednesday, January 29, 2003 3:50 PM
To: LazyDBA.com Discussion
Subject: RE: A true lazy question - and clarification -Correction
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] 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] 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] 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] 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