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

To save trace results to a file

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 select the Save to file check box.
   
   
4. Set the maximum file size in the Set maximum file size (MB) check box. You must set the maximum file size if you are saving trace results to a file.
   
   
5. Optionally, after saving the file, do the following:
   • Select the Enable file rollover check box, which creates new files to store the trace data if the maximum file size is reached. This option is selected by default when you are saving trace results to a file.
     
     
   • Select the Server processes SQL Server trace data check box.

     To avoid missing events, select this option.

See Also

Monitoring with SQL Profiler