|
Hi All, 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??
(comments are locked)
|
|
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. I'd say it wouldn't be advisable to include the descriptions in the capture even if it was doable. Event descriptions might change over time (Service packs etc). We use DB:s to normalise data, then I think it should be kept normalised if possible.
Jun 24 '10 at 10:21 AM
Magnus Ahlkvist
(comments are locked)
|
|
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...
(comments are locked)
|

