Google News
logo
SQL Server - Quiz(MCQ)
Which of the following argument has option value 2 in sp_trace_create procedure?
A)
SHUTDOWN_ON_ERROR
B)
TRACE_FILE_ROLLOVER
C)
TRACE_PRODUCE_BLACKBOX
D)
All of the above

Correct Answer :   TRACE_FILE_ROLLOVER


Explanation : As more rollover trace files are created, the integer value appended to the file name increases sequentially.

Advertisement