How to view a saved trace (Transact-SQL)
To view a specific trace
- Execute fn_trace_getinfo specifying the ID of the trace on which information is needed. This function will return a table listing the trace, trace property, and information about the property.
Invoke the function this way:
SELECT * FROM ::fn_trace_getinfo(trace_id)
To view all existing traces
- Execute fn_trace_getinfo specifying "0" or the term "default". This function will return a table listing all the trace, their properties, and information about these properties.
Invoke the function this way:
SELECT * FROM ::fn_trace_getinfo(default)