sqlfriends (1/20/2013)
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?
Thanks
-- 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