SSTS Blog

Some news and tidbits that we share

SQL Server function to read SQL Profiler trace files (fn_trace_gettable)

by SSTS
SSTS
Server Side Technology Solutions is a consulting firm that specializes in databa
User is currently offline
on Aug 07 in Blog 0 Comments

SQL Server Profiler creates files on the OS that can later be read in for analysis. 
The following parses a trace file and inserts the data into a table.
SELECT * INTO trace_folder
FROM::fn_trace_gettable('C:\mytrace.trc', 4)

Tags: Untagged
Hits: 5973

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

Comments

Please login first in order for you to submit comments