SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Event class in Trace Expand / Collapse
Author
Message
Posted Wednesday, December 05, 2007 1:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 12:32 PM
Points: 11, Visits: 181
Hi

IS there a way to display the event Class in text rather than the event id's in the table.
Basically I am trying to copy the trace fiel to a table and the event class shows the event id's and not the actual text.

Thanks
KR
Post #429905
Posted Wednesday, December 05, 2007 2:03 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 17,125, Visits: 12,226
Not from the trace itself, as far as I know. What you can do is create a lookup table with the event ids and the text values, then join the lookup to the trace.

The event classes and their ids are defined in books online



Gail Shaw

We walk in the dark places no others will enter
We stand on the bridge and none may pass

Post #429918
« Prev Topic | Next Topic »


Permissions Expand / Collapse