How to derive a template from a trace file or trace table (SQL Profiler)

To derive a template from a trace file or trace table

1. On the File menu, point to Open, and then click either Trace File or Trace Table.
   
   
2. If you choose to replay 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, and specify the database in which the table is saved in the Source Table dialog box.
   
   
3. Select the trace file to open, unless you have already selected a trace table to open.
   
   
4. On the File menu, point to Save As, and then click Trace Template.
   
   
5. Type a name and save the template file.

See Also

Monitoring with SQL Profiler