derive-a-template-from-a-trace-file-or-trace-table-sql-server-profiler.md

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	03/01/2017
ms.service	sql
ms.subservice	profiler
ms.topic	how-to
ms.collection	data-tools

Derive a Template from a Trace File or Trace Table (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance] This topic describes how to create a trace template from an existing trace file or table by using [!INCLUDEssSqlProfiler].

To derive a template from a trace file or trace table

1. 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).

2. On the File menu, point to Save As, and then click Trace Template.

3. Type a name or select one from the list. Click OK.

Note

If you select an existing template file, you are asked if you want to overwrite the file.

See Also

Create a Trace Template (SQL Server Profiler)
Modify a Trace Template (SQL Server Profiler)
Derive a Template from a Running Trace (SQL Server Profiler)
SQL Server Profiler