| title | Modify a Trace Template (SQL Server Profiler) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/01/2017 | |||
| ms.prod | sql-server-2016 | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | article | |||
| helpviewer_keywords |
|
|||
| ms.assetid | b81df2a1-e202-43d8-92b0-0beb145f0116 | |||
| caps.latest.revision | 26 | |||
| author | JennieHubbard | |||
| ms.author | jhubbard | |||
| manager | jhubbard |
This topic describes how to modify a trace template by using [!INCLUDEssSqlProfiler].
-
On the File menu, point to Templates, and then click Edit Template.
-
In the Trace Template Properties dialog box, on the General tab, you can modify the server type and template name, or choose to use a default template for the server type.
-
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, or click Save Asto save the trace template under another name.
Specify Events and Data Columns for a Trace File (SQL Server Profiler)
Derive a Template from a Running Trace (SQL Server Profiler)
Derive a Template from a Trace File or Trace Table (SQL Server Profiler)
SQL Server Profiler Templates and Permissions
SQL Server Profiler