| title | Create a Transact-SQL Script for Running a Trace | |
|---|---|---|
| titleSuffix | SQL Server Profiler | |
| description | Find out how to create a Transact-SQL script from an existing trace file or table in SQL Server Profiler. | |
| 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 Transact-SQL script from an existing trace file or table by using [!INCLUDE ssSqlProfiler].
-
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).
-
On the File menu, point to Export, point to Script Trace Definition, and then select the version that corresponds to the server you want to trace.
-
In the Save As dialog box, enter a name for the script file, and then select Save.