Trace Properties (Events Selection Tab)
Use the Events Selection tab of the Trace Properties dialog box to view or specify traced events and data columns.
- Events column
Specify traced events by selecting or clearing the check box in the event column. Events are organized by event category. Event classes specified in the template are automatically selected. For more information, see SQL Server Event Class Reference.
- Data columns
Specify traced data columns by checking the box that corresponds with the event and the data column you need. All relevant event columns are checked by default for each event included in the trace.
Specify filters by clicking the data column heading and entering the filter criteria. Filtered data columns are indicated by a filter icon to the left of the column label in the Edit Filter dialog box. For more information, see SQL Server Profiler - Edit Filter.
- Show all events
Show all available events. By default, only rows in the Events Selection grid that are selected display. Uncheck this box to hide all unselected events in the Events Selection grid.
- Show all columns
Show all available data columns. By default, only data columns that are selected display. Uncheck this box to hide all unselected data columns in the Events Selection grid.
- Column Filters
Launches the Edit Filter dialog box. You can use this dialog to edit data column filters.
- Organize Columns
Changes the order of columns in the trace and groups results by one or more columns.
Other ResourcesHow to: Specify Events and Data Columns for a Trace File (SQL Server Profiler)
How to: Organize Columns Displayed in a Trace (SQL Server Profiler)
How to: Filter Events in a Trace (SQL Server Profiler)
How to: View Filter Information (SQL Server Profiler)
How to: Modify a Filter (SQL Server Profiler)
Using SQL Server Profiler
SQL Server Profiler Reference