Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

How to: Extract a Script from a Trace (SQL Server Profiler)

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

To extract a Transact-SQL script from a trace file or table

  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 How to: Open a Trace File (SQL Server Profiler) or How to: Open a Trace Table (SQL Server Profiler).

  2. On the File menu, point to Export, point to Extract SQL Server Events, and then click Extract Transact-SQL Events.

  3. In the Save As dialog box, type a name for the Transact-SQL file, and click Save.

Community Additions

© 2015 Microsoft