Modify a Trace Template (SQL Server Profiler)
This topic describes how to modify a trace template by using SQL Server Profiler.
To modify a trace template
-
On the File menu, point to Templates, and then click Edit Template.
-
In the Trace Template Properties dialog box, on the General tab, you can modify the server type and template name, or choose to use a default template for the server type.
-
On the Events Selectiontab, use the grid control to add or remove events and data columns from the trace file as follows.
-
To add an event, expand the appropriate event category in the Events column, and then select the event name.
-
When you add an event, all relevant data columns are included by default. To remove a data column for an event from a trace, clear the check box in the data column for the event.
-
To add filters, click the data column name and specify the filter criteria in the Edit Filter dialog box. You can also right-click the data column name, and click Edit Column Filter to launch the Edit Filter dialog box. Click OK to add the filter.
-
-
Click Save, or click Save Asto save the trace template under another name.
