SQL Server: Determining Running Traces

Question

Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000?

Answer 1

SQL Server 2000 :

SELECT * FROM fn_trace_getinfo(default);

(Ref fn_trace_getinfo)

SQL Server 2005 (onwards):

SELECT * FROM sys.traces