Haidong, thank you for your reply.

I used the extended stored procedure created a couple of trace running on SQL 7, we are in the process of upgrading to SQL 2000.

In SQL 7, there is an extended stored procedure: xp_trace_setqueueautostart

which will make the trace automatically started whenever the server is reboot. But i didn't find the same thing in SQL 2000, that's why i asking the question.

I thought the way you mentioned before, it will restart the trace whenever the Agent is restart, but what happen if you only restart the Agent without restarting the SQL Server ?

Again, thank you for your help.