Explanation:Stop and Close the the trace with sp_trace_setstatus. 5. Point out the wrong statement :
A. If a filter is set, all events of the selected event classes are returned in the trace output.
B. A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors.
C. A data column is an attribute of an event classes captured in the trace.
D. All of the mentioned
Answer:A
Explanation:Stop and Close the the trace with sp_trace_setstatus. 5. Point out the wrong statement :
A. If a filter is set, all events of the selected event classes are returned in the trace output. B. A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors. C. A data column is an attribute of an event classes captured in the trace. D. All of the mentioned
Explanation:When you create a trace or template, you can define criteria to filter the data collected by the event. To keep traces from becoming too large, you can filter them so that only a subset of the event data is collected. 6. Which of the following is syntax for sp_trace_setevent ?