Re: SQL profiler question

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: SQL profiler question
    ... 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: 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: tracking SPID back to the user or client
    ... You can run a trace and at some point you should see a cursor prepare ... Andrew J. Kelly SQL MVP ... or database code to see why it is blocking and fix the source. ... The connection is made through ODBC. ...
    (microsoft.public.sqlserver.connect)
  • 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 Reader
    ... Is there a way i can keep the trace ... > Andrew J. Kelly SQL MVP ... >> that i dont know yet i could create the tracing, but now i am having a new ... >> comand to stop and clear the trace and re run the commands and it say the ...
    (microsoft.public.sqlserver.programming)