Nooks in SQL Server – Part 2

To read the trace file using querying / To Query the trace files from profiler

Do call the below function and results are in grid

 

    SELECT * FROM ::fn_trace_gettable('D:\Test\test.trc', default)

You can alternatively can store the result to a table by using

Select * into tablename…

-Yuva