How capture displays from procs?

#1

I have strored procedures which sometimes start and end with something like
"SELECT 'pgmname:', getdate() as 'started'". Sometimes row counts are
included and other important stuff. Anyway, when I run these same procs
from DTS I lose this information as the package log does not capture it. Is
there a way to capture this stuff in the log?

Thanks,
Michael

#2

Create a log table and insert this inf there instead.

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have strored procedures which sometimes start and end with something like
"SELECT 'pgmname:', getdate() as 'started'". Sometimes row counts are
included and other important stuff. Anyway, when I run these same procs
from DTS I lose this information as the package log does not capture it.
Is
there a way to capture this stuff in the log?

Thanks,
Michael

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

How capture displays from procs?

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

How capture displays from procs? - 06-03-2005 , 10:30 AM

Re: How capture displays from procs? - 06-03-2005 , 01:53 PM