How to view a saved trace (Transact-SQL)

To view all saved traces by name

• Execute xp_trace_enumqueuedefname without the queue-name parameter to retrieve all currently defined queue names.

To view all active traces by queue handle

• Execute xp_trace_enumqueuehandles without the queue-handle parameter to list all currently defined queue handles.

See Also