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.

To create a Transact-SQL script to run a trace

  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.

See Also

Other Resources

Using SQL Server Profiler
SQL Server Profiler Reference

Help and Information

Getting SQL Server 2005 Assistance