Re: Similar question about Auto Startup Trace

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

Date: Fri, 13 Feb 2004 19:03:56 -0800

You should uncheck 'save to table' based on your earlier posts. It should be
on the general definition page in the Profiler. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Harry G" <anonymous@discussions.microsoft.com> wrote in message
news:1067901c3f2a3$c7525a80$a501280a@phx.gbl...
> Kalen, Would you please tell me which option I should
> uncheck it before I script the definition of the trace and
> where is it?
>
> Thanks you,
> Harry
> >-----Original Message-----
> >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

  • Re: Similar question about Auto Startup Trace
    ... If I script the trace like this, when the trace auto ... >Kalen Delaney ...
    (microsoft.public.sqlserver.tools)
  • Re: Similar question about Auto Startup Trace
    ... The auto started trace should be writing to a file, ... SQL Server MVP ... "Harry G" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • Re: Similar question about Auto Startup Trace
    ... >HI Harry ... >The auto started trace should be writing to a file, ... >> After the trace auto startuped when SQL server startup, ...
    (microsoft.public.sqlserver.tools)
  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)