Properties (Data Columns Tab)

SQL Profiler Help

SQL Profiler Help

Properties (Data Columns Tab)

Use this tab to view or specify the following options.

Options

Unselected data

View all data columns not selected to capture in the trace or trace template.

Selected data

View all data columns selected to capture in the trace or trace template. Event Class and SPID are required columns and cannot be moved from the Selected data list.

Add

Add columns to the Selected Data list, specifying by which columns to group the trace. You cannot group by the EndTime or StartTime data columns.

Remove

Remove columns from the Selected Data list.

Up

Move a selected column up the list of selected columns or group-by columns.

Down

Move a selected column down the list of selected columns or group-by columns.

See Also

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

Monitoring with SQL Profiler Event Categories