Auditing SQL Trace Data Files

To delete a trace

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 main advantage with Data centers services, we do not have to worry about theft, viruses, spam, hackers, and even disasters. Data center make you able to restore your lost data anytime whenever disaster occur. It is considered as the best way to protect your sensitive business data.