Running ALTER TABLE and DROP PROC

#1

Is it possible to run SQL statements like drop proc and
create proc through DTS?

#2

Just use an Execute SQL Task. This can run scripts on almost anything.

--
Darren Green
http://www.sqldts.com

"vuntshun.chia (AT) guardeonic (DOT) com" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message news:0a2d01c3d446$cb9429f0$a101280a (AT) phx (DOT) gbl...

Quote:

Is it possible to run SQL statements like drop proc and
create proc through DTS?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Running ALTER TABLE and DROP PROC

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Running ALTER TABLE and DROP PROC - 01-06-2004 , 06:18 AM

Re: Running ALTER TABLE and DROP PROC - 01-06-2004 , 06:55 AM