Explanation:Adds or removes an event or event column to a trace. sp_trace_setevent may be executed only on existing traces that are stopped. 7. Which of the following argument has option value 2 in sp_trace_create procedure ?
A. TRACE_PRODUCE_BLACKBOX
B. SHUTDOWN_ON_ERROR
C. TRACE_FILE_ROLLOVER
D. All of the mentioned
Answer:A
Explanation:Adds or removes an event or event column to a trace. sp_trace_setevent may be executed only on existing traces that are stopped. 7. Which of the following argument has option value 2 in sp_trace_create procedure ?
A. TRACE_PRODUCE_BLACKBOX B. SHUTDOWN_ON_ERROR C. TRACE_FILE_ROLLOVER D. All of the mentioned
Explanation:As more rollover trace files are created, the integer value appended to the file name increases sequentially. 8. Which of the following events and their columns are contained in the trace: