SQL Server Trace Event Definitions
If you are using Event Notifications or capturing events
in Profiler you undoubtedly have noticed that MS have used the same columns (xml
elements) for storing different data for each event. For example there is an
element called "integer data". You may ask what is stored in here cos it ain't
obvious from the name of the element.
Help is at hand but it's not obvious. I spent a while digging through BOL and
found the pages you need.
The top level page is called "SQL Server Event Class Reference" and can
be found with thi BOL
link ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/0f0fe567-e115-4ace-b63c-73dc3428c0f6.htm
This page provides a link to all the pages that detail what all the elements
mean for each event class.
In addition you can use the index and go to the pages directly. The name of
the page is "<event name> event class" i.e.
"Exception event class" with a BOL link of
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5a45dfa7-51fc-420c-96f6-ce2a1f61b684.htm
-