How to save trace results to a table (SQL Profiler)

How to save trace results to a table (SQL Profiler)

To save trace results to a table

1. On the File menu, point to New, and then click Trace.
   
   
2. In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
   
   
3. In the Trace name box, type a name for the trace, and then click Save to table.
   
   
4. In the Destination Table dialog box, do the following:
   • In the Database list, select the destination database.
     
     
   • In the Table list, type or select the table name for the trace results.
5. Select the Set maximum rows (in thousands) check box to specify the maximum number of rows to save.

See Also

Monitoring with SQL Profiler