SQL Profiler Trace Events

Question 1

T-SQL to query saved trace file?

Answer 1

select
spid,
StartTime,
Textdata,
EventSubclass,
ObjectID,
DatabaseID,
SQLHandle
from
fn_trace_gettable ( ‘e:\recompiletrace.trc’ , 1)