Post reply

check traces

  • January 20, 2013 at 5:39 pm

    #287827

    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

  • 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

  • January 22, 2013 at 9:14 am

    #1579692

    Thanks much, it works.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply