EventClass conversion anyone?

  • Before I go and create something homegrown, does anyone know of an easier way of converting EventClass to its text description?* The root DMV / system table / function that Profiler uses perhaps? Even the chart in BOL isn't complete.

    I've found Kalen Delaney's script but it's outdated. (Closest I could get via Google.)

    *Other than plugging the table/file back into Profiler that is.

    Heck, I even tried my old trick of running a Profiler trace (on a Profiler load) to no avail. The only thing that comes through is a bunch of sp_cursor calls and none of them are informative.

  • This article lists the eventClass items and it says it was updated this month:

    http://msdn2.microsoft.com/en-us/library/ms186265.aspx

    Hope this helps,

    Kathi

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • Yeah, got that (it's the online version of the BOL article I mentioned). Unfortunately there's no real easy way to convert that into a script. Besides, even that isn't complete.

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

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