SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » Event class in Trace

Event class in Trace Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
sanra001
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
GilaMonster
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

 
 
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use