How to add or remove data columns from a trace template (SQL Profiler)

How to add or remove data columns from a trace template (SQL Profiler)

To add or remove data columns from a trace template

1. On the File menu, point to Open, and then click Trace Template.
   
   
2. Select the template file to open.
   
   
3. In the Trace Template Properties dialog box, click the Data Columns tab.
   
   
4. In Unselected data list, click a data column, and then click Add to add the data column to the data that will be captured.
   
   
5. In the Selected data list, click a data column, and then click Remove to remove the data column from the data that will be captured.
   
   
6. In the Selected data list, click an individual data column, and then click Up or Down to order the data column.

See Also

Monitoring with SQL Profiler