You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/tools/sql-server-profiler/modify-trace-templates.md
+13-21Lines changed: 13 additions & 21 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -22,38 +22,30 @@ ms.author: "jhubbard"
22
22
manager: "jhubbard"
23
23
---
24
24
# Modify trace templates
25
-
You can modify templates that are saved in a file on the local computer on which [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] is running. You can also modify templates derived from those files. When you modify existing templates, you edit template properties such as event classes and data columns, in the same order that the properties were set originally, on the **Events Selection** tab of the **Trace Properties** dialog box. Event classes and data columns can be added or removed, and filters can be changed. After the template is modified, a user-specific template is created and the original system template is left intact. For more information, see [Save Traces and Trace Templates](../../tools/sql-server-profiler/save-traces-and-trace-templates.md).
26
-
27
-
You may need to derive a template from an existing trace file if you cannot remember (or have not saved) the original template that was used to create the trace, or if you want to run the same trace at a later date. When working with existing traces, you can view the properties, but you cannot modify the properties. To modify the properties, stop or pause the trace. For more information, see [Derive a Template from a Trace File or Trace Table (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-trace-file-or-trace-table-sql-server-profiler.md) and [Derive a Template from a Running Trace (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-running-trace-sql-server-profiler.md).
28
-
25
+
You can modify templates that are saved in a file on the local computer on which [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] is running. You can also modify templates derived from those files. When you modify existing templates, you edit template properties such as event classes and data columns, in the same order that the properties were set originally, on the **Events Selection** tab of the **Trace Properties** dialog box. Event classes and data columns can be added or removed, and filters can be changed. After the template is modified, a user-specific template is created and the original system template is left intact. For more information, see [Save Traces and Trace Templates](../../tools/sql-server-profiler/save-traces-and-trace-templates.md).
26
+
27
+
You may need to derive a template from an existing trace file if you cannot remember (or have not saved) the original template that was used to create the trace, or if you want to run the same trace at a later date. When working with existing traces, you can view the properties, but you cannot modify the properties. To modify the properties, stop or pause the trace. For more information, see [Derive a Template from a Trace File or Trace Table (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-trace-file-or-trace-table-sql-server-profiler.md) and [Derive a Template from a Running Trace (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-running-trace-sql-server-profiler.md).
28
+
29
29
## To modify a trace template
30
30
31
31
1. On the **File** menu, point to **Templates**, and then click **Edit Template**.
32
32
33
33
2. 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.
34
34
35
-
3. On the **Events Selection**tab, use the grid control to add or remove events and data columns from the trace file as follows.
35
+
3. On the **Events Selection**tab, use the grid control to add or remove events and data columns from the trace file as follows.
36
36
37
37
- To add an event, expand the appropriate event category in the **Events** column, and then select the event name.
38
38
39
39
- 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.
40
40
41
41
- 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.
42
42
43
-
4. Click **Save**, or click **Save As**to save the trace template under another name.
44
-
**To create a trace template**
45
-
43
+
4. Click **Save**, or click **Save As** to save the trace template under another name.
44
+
46
45
## Next steps
47
-
**To start a trace**
48
-
[Start a Trace](../../tools/sql-server-profiler/start-a-trace.md)
49
-
**To run a trace from a trace template**
50
-
[Create a Trace (SQL Server Profiler)](../../tools/sql-server-profiler/create-a-trace-sql-server-profiler.md)
[Start a trace](../../tools/sql-server-profiler/start-a-trace.md)
47
+
[Create a trace](../../tools/sql-server-profiler/create-a-trace-sql-server-profiler.md)
48
+
[Modify an existing trace using Transact-SQL](../../relational-databases/sql-trace/modify-an-existing-trace-transact-sql.md)
49
+
[Specify events and data columns for a trace using SQL Server Profiler](../../tools/sql-server-profiler/specify-events-and-data-columns-for-a-trace-file-sql-server-profiler.md)
0 commit comments