Posted by Karthick P.K on April 26, 2010
select
[Status] =
case tr.[status]
when 1 THEN 'Running'
when 0 THEN 'Stopped'
end
,[Default] =
case tr.is_default
when 1 THEN 'System TRACE'
when 0 THEN 'User TRACE'
end
,[login_name] = coalesce(se.login_name,se.login_name,'No reader spid')
,[Trace Path] = coalesce(tr.[Path],tr.[Path],'OLE DB Client Side Trace')
from sys.traces tr
left join sys.dm_exec_sessions se on tr.reader_spid = se.session_id
Like this:
Like Loading...
Posted in SQL Query | Tagged: Find all the SQL Server traces, SQL Query, SQLServer profiler traces listing | 4 Comments »
MSSQLWIKI 