Home Forums SQL Server 2008 SQL Server 2008 Administration check traces RE: check traces

  • January 20, 2013 at 10:32 pm

    #1579082

    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