PAH-440118 (12/2/2010)
What is the command to delete to the trace definition?
Right here in the Books Online:
1.Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.
2.Execute sp_trace_setstatus by specifying @status = 2 to close the trace and delete its information from the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning