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
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