Trim a table..do you mean truncate?

Thanks david..your solution works..thanks a lot...

This SP will invoke at midnight to start capturing traces and willl stop at 11:59:59:00 PM on the same day to generate trace file of all the events captured that...