Re: SQL profiler question

Andrew,
I created the trace to load a file. I tried to use the fn_trace_gettable
but I got an error:"File 'C:\test_Website_Trace.trc' either does not exist or
is not a recognizable trace file. Or there was an error opening the file."
Thanks,
joe


"Andrew J. Kelly" wrote:

> Take a look at sp_trace_setevent in BooksOnLine. You may want to use one of
> the 3rd party log sniffer tools for something like this as it can make life
> a lot easier. I also don't recommend tracing directly to a table for
> performance reasons. Trace to a file and then use fn_trace_gettable to
> import it to a table later on.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "jaylou" <jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:531882AB-E152-4227-B4D0-6A8D4F3CC73F@xxxxxxxxxxxxxxxx
> > Hi All,
> > I am trying to capture every time either SA or a DB_owner adds, changes,
> > or
> > deletes a user. Basically I am looking to trap all security functions on
> > my
> > SQL servers.
> > I started a trace that loads a table. The only problem is that the event
> > class is a number not the description. Is there a reference table for
> > this
> > or is there a way to load the description?
>
>
>
.

Relevant Pages

  • Re: Closing an opening window
    ... based directly on the Form class. ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... I can't call close or dispose in load>> without ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Closing an opening window
    ... Andrew J. Kelly SQL MVP ... >> InitializeComponentand tested it's value in the LOAD() of the form. ... >> Andrew J. Kelly SQL MVP ... >>> while creating the window handle. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Log Reader
    ... Andrew J. Kelly SQL MVP ... >> though you may be runing the script from QA on your machine the trace ... >> Andrew J. Kelly SQL MVP ... >>> comand to stop and clear the trace and re run the commands and it say ...
    (microsoft.public.sqlserver.programming)
  • Re: automating profiler
    ... Andrew J. Kelly SQL MVP ... >> want to trace directly to a table if you care about performance. ... >> Andrew J. Kelly SQL MVP ... >> produce reports with Reporting Services. ...
    (microsoft.public.sqlserver.tools)
  • Re: Log File is growing
    ... Thankes Andrew ... bulk load', 'true' ... > get a minimally logged load. ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.dts)