Re: SQL profiler question

Do you know of a reference table that holds eventID and description? 

Yep. Check out http://www.sqldev.net/misc.htm

--
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:64769B7A-9A29-4BB5-8F64-62220A2A3976@xxxxxxxxxxxxxxxx 
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: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 Profiler
    ... You can load a trace fileor multiple if you've specified rollover ... Jasper Smith (SQL Server MVP) ... "Kevin H" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • Re: DTS - Triggers and Defaults Not Firing
    ... And that option is to uncheck "use fast load" ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > be updated via insert and update triggers. ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to load a database file
    ... Mike Epprecht, Microsoft SQL Server MVP ... "Unable to load a database file" <Unable to load a database ...
    (microsoft.public.sqlserver.server)
  • Re: SQL profiler question
    ... Tibor Karaszi, SQL Server MVP ... I created the trace to load a file. ...
    (microsoft.public.sqlserver.tools)