Re: SQL profiler question

Yes that was my first thought.

Do you know of a reference table that holds eventID and description? The
description doesn't seem to load into the table when I run the trace directly
into a table.

Thanks,
Joe


"Tibor Karaszi" wrote:

> Did you stop and close the trace?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "jaylou" <jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:379EB231-57D9-4EDE-A2F6-6B1250FF4E7F@xxxxxxxxxxxxxxxx
> > 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: Why I/Oread is a low Num on the exec. Plan but very high on tr
    ... Well they both show 3 million at the trace and the same IOs. ... > Andrew J. Kelly SQL MVP ... I was actually using the migration time to recreate indexes. ... >> very low number before I do the db reindex. ...
    (microsoft.public.sqlserver.server)
  • 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: SQL profiler question
    ... I created the trace to load a file. ... "Andrew J. Kelly" wrote: ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Setting up Trace in SQL
    ... > The company has a policy and states that we have to audit> our databases. ... >>SQL Server MVP ... But supposed if I were to re-start the DB, the>>> audit does not kick off at all coz the trace files still ...
    (microsoft.public.sqlserver.security)