Re: Similar question about Auto Startup Trace

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 14:06:39 -0800

HI Harry

The auto started trace should be writing to a file, so it is auto saved
there. You could create a job to stop the trace at regular intervals (every
hour?), close it, copy the file to a table, and the restart the trace. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Harry G" <anonymous@discussions.microsoft.com> wrote in message
news:100e101c3f26c$e576be20$a401280a@phx.gbl...
> Hi,
>
> After the trace auto startuped when SQL server startup,
> Is there any way to AUTO save the data into a table or
> AUTO save the data into a file? Any ideas?
>
> Thanks in Advance,
> Harry

Relevant Pages