The query, database and server haven't gone through any recent changes, but the user load has been steadily increasing. Changing the query or schema (adding indexes) is possible, but...

Here is the query. It's an accounting application. Transactions are in the trans table and details about those transactions are in the detail table. The query is...

Wish I had an answer, but did want to reply that I am seeing the same issue.

Thank you all for the help, this has been working great on SQL 2005. I know this is a SQL 2005 forum and I can open a new topic...

Many thanks Jack, Itzik's method is exactly what I am looking for.

Thanks, when I initially saw that I interpreted it to mean the trace would stop once the max files was reached.