Explanation:The event class contains all of the data that can be reported by an event. 4. Which of the following stored procedure will stop the trace ?
A. sp_trace_create.
B. sp_trace_setfilter
C. sp_trace_setstatus
D. sp_stop_status
Answer:A
Explanation:The event class contains all of the data that can be reported by an event. 4. Which of the following stored procedure will stop the trace ?
A. sp_trace_create. B. sp_trace_setfilter C. sp_trace_setstatus D. sp_stop_status
Explanation:Stop and Close the the trace with sp_trace_setstatus. 5. Point out the wrong statement :