September 27, 2007 at 4:44 pm
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.
September 27, 2007 at 10:44 pm
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
September 28, 2007 at 10:55 am
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