Edit

Share via


Create a Transact-SQL script for running a trace (SQL Server Profiler)

Applies to: 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 SQL Server Profiler.

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

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