How to modify a trace template (SQL Profiler)

How to modify a trace template (SQL Profiler)

To modify a trace template

1. On the File Menu, point to Open, and then click Trace Template.
   
   
2. Select the trace template file to open.
   
   
3. In the Trace Template Properties dialog box, specify the trace template configurations by doing the following:
   • Click the Events tab to modify the list of selected event classes.
     
     
   • Click the Data Columns tab to modify the list of selected data.
     
     
   • Click the Filters tab to modify the criteria for determining which events to capture. To add or edit criteria, expand the trace event and then type the criteria in the field that appears beneath the trace criterion.

   These modifications are effective the next time the trace template is used for a trace.

4. Click Save, or click Save As to save the trace template under another name.

See Also

Monitoring with SQL Profiler