Let the eventclassid stored in the Profiler trace table correspond to its name

I often look at the SQL Profiler trace and feel that it is not convenient to store it as a file. After storing it in a database table, you can simply query it.

 

However, the eventclassid column in the saved table displays numbers, unlike the ones used in profiler.ProgramShown

RPC: Starting
SP: Starting
SP: stmtstarting

And so on.

 

After searching online, I found the following script to display eventclassid as the name.

SelectTe.Name,T.*FromDBO.Trace t-- Table that contains the trace resultsJoinSys.Trace_eventsTeOnT.Eventclass=Te.Trace_event_idOrderRownumber
 

 

Script source:

Map SQL Server Profiler eventclass ID to its name in a saved trace table

http://weblogs.sqlteam.com/mladenp/archive/2007/11/09/Map-SQL-Server-Profiler-EventClass-ID-to-its-name-in.aspx