I have implemented Michael's article successfully. I have a sql trace running and capturing data into table IndexCapture.

But when I try to implement the trigger provided by Solomon on table IndexCapture ( I changed the table name in the trigger), the trigger gets created successfully but immediately after that an error pops up in SQL Profiler 'Failed to save trace data to table' and the trace is stopped.

Any ideas, why this might be happening? I am working on SQL Servr 2005 SP2, not SQL Server 2000.

The table and trigger are in same the database and in the same SQL Server instance.

Thanks!