How to save a template, trace file, or trace table to SQL Script (SQL Profiler)

How to save a template, trace file, or trace table to SQL Script (SQL Profiler)

To save a template, trace file, or trace table to SQL Script

1. On the File menu, point to Open, and then click Trace Template, Trace File, or Trace Table.
   
   
2. If you choose to save a trace table, you must enter the connection information. In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
   
   
3. In the Open dialog box, select a trace template, trace file, or trace table to save.
   
   
4. On the File menu, point to Save As, and then click SQL Script.

See Also

Monitoring with SQL Profiler