How to import SQLProfiler trace into SQLSERVER database

• Samx

  SSC Eights!

  Points: 999

  More actions

  November 23, 2005 at 9:50 am

  #90030

  Hi,

  Do you know a script which allow to import into a table in SQLSERVER, a trace file generated by SQLProfiler ?

  Thanks in advance.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  November 23, 2005 at 10:34 am

  #605506

  Look in Books OnLine for function fn_trace_gettable

  Example usage:

  SELECT *

  INTO temp_trc

  FROM ::fn_trace_gettable('c:\my_trace.trc', default)

  SQL = Scarcely Qualifies as a Language