Create

This article describes how to create a new trace template by using SQL Server Profiler.

1. On the

menu, point to

, and then select.

2. In the

dialog box, select a server type from the

list.

3. In the

box, enter a template name.

4. Optionally, select

, and then select a template from

the list.

All events, data columns, and filters are initially set as specified in the selected template.

5. Optionally, select.

6. On the

tab, add, remove, or modify events, data columns, or filters.

7. On the

tab, 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

column and

select the event name.

All relevant data columns are included by default when you add an event. 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, select the data column name and specify the filter criteria in the

dialog box. You can also right-click the data column name and select

to launch the

dialog box. Select

to add the filter.

8. Select.