Re: automating profiler

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jo (Jo_at_discussions.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 12:17:01 -0700

Do you know anything about the xp_trace_opentracefile stored proc in 7.0? Is it possible that this will do the same thing as fn_trace_gettable in 2000?

"Andrew J. Kelly" wrote:

> Not that I am aware of.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Jo" <Jo@discussions.microsoft.com> wrote in message
> news:DC0B3779-1875-40D4-848B-31473782A038@microsoft.com...
> > Is there a SQL 7.0 soluthion?
> >
> > "Andrew J. Kelly" wrote:
> >
> > > Sure, take a look at fn_trace_gettable in BOL. By the way you almost
> never
> > > want to trace directly to a table if you care about performance.
> > >
> > > --
> > > Andrew J. Kelly SQL MVP
> > >
> > >
> > > "Jo" <Jo@discussions.microsoft.com> wrote in message
> > > news:75FFDF10-B0AA-4AD4-8573-0A241F630717@microsoft.com...
> > > > I have created a stored proc that will automate the capture of traces.
> The
> > > trace is captured to a file instead of a table because tracing to a
> table on
> > > the same server has caused performance issues.
> > > >
> > > > The problem is that I really want the trace in a table so that we can
> > > produce reports with Reporting Services. I know that I can manually save
> the
> > > trace to a trace table. But is there a way to automate this process? I
> can't
> > > find any command line parameters for Profiler.
> > > >
> > > >
> > > >
> > >
> > >
> > >
>
>
>