Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.