Create a Trace Template (SQL Server Profiler)
This topic describes how to create a new trace template by using SQL Server Profiler.
To create a trace template
-
On the File menu, point to Templates, and then click New Template.
-
In the Trace Template Properties dialog box, select a server type from the Select server typelist.
-
In the New template name box, enter a template name.
-
Optionally, click Base new template on existing one, and then select a template from the list.
All events, data columns, and filters are initially set as specified in the selected template.
-
Optionally, click Use as a default template for selected server type.
-
On the Events Selection tab, add, remove, or modify events, data columns, or filters.
-
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.
