How to set a maximum table size for a trace table (SQL Profiler)
To set a maximum table size for a trace table
- On the File menu, point to New, and then click Trace.
- In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
- In the Trace Properties dialog box, in the Trace name box, type a name for the trace.
- Select the Save to table check box, and then specify a table in which to store the trace information.
You will be prompted to connect to the server on which you want the trace to be stored.
- In the Destination Table dialog box, in the Database list, select a database for the trace, and then in the Table box, type or select a table name.
- Select the Set maximum rows (in thousands) check box and specify a maximum number of rows for the trace table.
When the number of rows in the table exceeds this maximum, the trace events are no longer recorded.