Is there a way to find out what traces are enabled in a sql server instance?
and also what is the default traces that are turned on?
-- all traces
SELECT * FROM sys.traces;
-- the default trace
SELECT * FROM sys.traces WHERE is_default = 1;
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato