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: Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)

This topic describes how to create a Transact-SQL script from an existing trace file or table by using SQL Server Profiler.

  1. Open a trace file or table. 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 Script Trace Definition, and then click For SQL Server 2005, For SQL Server 2000, or For Analysis Services 2005, depending on the server that is to be traced.

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

Community Additions

© 2015 Microsoft