How do I find running Traces in SQL Server?

By : GordyII

Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000? How about for SQL Server 2005, 2008, 2012, or 2014?

By : GordyII


Old question, but a precisation. On a SQL 2000 server you must use msdb database. Es:

USE msdb
SELECT * FROM :: fn_trace_getinfo(default) 
By : user_0

SQL Server 2005 (onwards):

    SELECT * FROM sys.traces

SQL Server 2000 :

    SELECT * FROM fn_trace_getinfo(default);

(Ref fn_trace_getinfo)

run xdpyinfo and see if it returns an zero

By : shuckc

This video can help you solving your question :)
By: admin