How do I find running Traces in SQL Server?

SQL Server 2005 (onwards):

    SELECT * FROM sys.traces

SQL Server 2000 :

    USE msdb
    SELECT * FROM fn_trace_getinfo(default);

Ref: fn_trace_getinfo

Column descriptions for sys.traces DMV can be found here: sys.traces

Leave a Comment