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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)