How to read a SQL Profiler trace file in Management studio – SQL Server

fn_trace_gettable (‘filename’ , number_files )

number_files specifies the number of rollover files to be read.

SELECT *
FROM fn_trace_gettable(‘c:\inside_sql.trc’, 1)