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)
  

See Also

Creating and Managing Traces and Templates

fn_trace_getinfo

Viewing and Analyzing Traces