Importing trace files from SQL Profiler
When running a trace using SQL Profiler we need to be Importing trace files to perform some analysis on the results. To import the files we will simply use the fn_trace_gettable function. SELECT * INTO tracetable FROM dbo.fn_trace_gettable (‘C:\tracefiles\trace_1_1.trc’, default)