SQL Profiler: Results 1

[rzirpolo]

I am pretty new in regards to using Trace in SQL Profiler. Lookin at my results in the table the EventClass comes back as a number. Can this be linked to a system table to find out what event class this was, as in the text ?

Also when looking at the associated TextData field a number of them state "<Long Text>", which really doesn't help me investigate. Is there a limit on how many characters can be exported to a field ?

 

[vongrunt]

In most cases you'll need only EventClass 12 (SQL:BatchCompleted). For full list, refer to sp_trace_setevent topic in BOL.

About "<Long Text>": just expand column in grid view and text will appear. TextData column is ntext type.