derive-a-template-from-a-running-trace-sql-server-profiler.md

title	Derive a Template from a Running Trace (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date	03/01/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	templates [SQL Server], traces trace templates [SQL Server]
ms.assetid	25a3b845-affb-4b2a-a382-198a4bdd9ad1
caps.latest.revision	26
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

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

This topic describes how to create a trace template from an existing trace while it is running by using [!INCLUDEssSqlProfiler].

To derive a template from a running trace

1. If necessary, switch to the window that contains the trace.

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. You can only select a user-defined template. Predefined system trace templates cannot be overwritten.

See Also

SQL Server Profiler Templates and Permissions
Create a Trace Template (SQL Server Profiler)
Modify a Trace Template (SQL Server Profiler)
SQL Server Profiler