Re: SQL profiler question

Thank you I will take a look.
Thanks for the info!

"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: 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: SQL profiler question
    ... the 3rd party log sniffer tools for something like this as it can make life ... Trace to a file and then use fn_trace_gettable to ... Andrew J. Kelly SQL MVP ... > I started a trace that loads a table. ...
    (microsoft.public.sqlserver.tools)
  • 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: How to display the command text when a long transaction is on proc
    ... The only way to see what line is actually executing is to start a trace ... beforehand with stmt:starting event. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL profiler question
    ... I created the trace to load a file. ... "Andrew J. Kelly" wrote: ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)