When I save data from SQL Server trace file to a SQL table, the EventClass column shows ID and not description. I mean, EventClass column for SQL:BatchCompleted shows 12 and not original description.
Can this be changed??
asked Jun 24, 2010 at 05:09 AM in Default
Quick and dirty way to deal with this is to create a view, similar to:
Of course, you may want to trim the columns down a bit...
answered Jul 27, 2010 at 05:24 AM
The Event IDs and descriptions are found in
One option could be to join to this catalog view when querying the trace data.
When using the Profiler UI, the translation is made for you - not sure you can make the trace store the actual descriptions.
answered Jun 24, 2010 at 05:52 AM
Kev Riley ♦♦