create-a-transact-sql-script-for-running-a-trace-sql-server-profiler.md

title	titleSuffix	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.collection
Create a Transact-SQL Script for Running a Trace	SQL Server Profiler	Find out how to create a Transact-SQL script from an existing trace file or table in SQL Server Profiler.	rwestMSFT	randolphwest	03/01/2017	sql	profiler	how-to	data-tools

Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)

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

To create a Transact-SQL script to run a trace

1. Open a trace file or table. For more information, see Open a Trace File (SQL Server Profiler) or Open a Trace Table (SQL Server Profiler).

2. On theFilemenu, point to Export, point to Script Trace Definition, and then click the version that corresponds to the server you want to trace.

3. In the Save As dialog box, enter a name for the script file, and then click Save.

See Also

SQL Server Profiler Templates and Permissions
SQL Server Profiler