| title | Derive a Template from a Trace File or Trace Table | |
|---|---|---|
| titleSuffix | SQL Server Profiler | |
| description | Discover how to use SQL Server Profiler to create a trace template from an existing trace file or from a trace table stored in a database. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 06/05/2025 | |
| ms.service | sql | |
| ms.subservice | profiler | |
| ms.topic | how-to | |
| ms.collection |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This article describes how to create a trace template from an existing trace file or table by using [!INCLUDE ssSqlProfiler].
-
Open the trace file or trace table on which you want to base your template. For more information, see Open a trace file (SQL Server Profiler) or Open a trace table (SQL Server Profiler).
-
On the File menu, point to Save As, and then select Trace Template.
-
Type a name or select one from the list. Select OK.
If you select an existing template file, you're asked if you want to overwrite the file.