How do I find running Traces in SQL Server?

By : GordyII
Source: Stackoverflow.com
Question!

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


Answers

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