Post reply

Decoding EventClass in Profiler Table

  • November 12, 2004 at 2:13 pm

    #87038

    I ran a Profiler trace to a file, and then used fn_trace_gettable to put it in a SQL Server 2K table.  Now that it's in the table, I can see that Profiler seems to have converted the eventclass number to a text string.  Is there a system function that will decode eventclass and eventsubclass into text for me, or do I have to write one myself?

    Also, there are fields in the table called objectid and objecttype.  Do those values correspond to something that I can decode as well?

    Thanks,

    MattieNH

     

     

     

  • November 12, 2004 at 2:22 pm

    #530015

    Before you start, read this http://www.insidesql.de/content/view/160/ It's based on a great posting from 5400andsoon (aka Len Esterhuyse) here some time ago. You might also find it here via a forum search.

    Hey Len, I haven't seen you posting here for ages!

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 15, 2004 at 6:58 am

    #530091

    Thanks so much for saving me all that typing.

    Any thoughts on what objectid and objecttype correspond to?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply