DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops
profiler
#profiler#extract-a-script-from-a-trace

Extract a Script from a Trace

This article describes how to extract Transact-SQL events from a trace file or table and save

them as a Transact-SQL script file by using SQL Server Profiler.

  1. Open a trace file or table that contains Transact-SQL events that you want to save to a

Transact-SQL script file. For more information, see

Open a trace file (SQL Server Profiler)

or

Open a trace table (SQL Server Profiler).

  1. On the

menu, point to

, point to

, and then select.

  1. In the

dialog box, type a name for the Transact-SQL file, and select.

Profiler