Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2010
    Posts
    5

    Unanswered: How to check MSSQL trace settings

    Hi All,

    Would like to know is there anyway to check the current trace been configure in MSSQL DB?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Trace flags?
    Code:
    DBCC TRACESTATUS()
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Code:
    select *
    from dbo.fn_trace_getinfo(default)
    EDIT: This is for profiler traces only. Pootle's answer is for Trace Flags.

  4. #4
    Join Date
    Jul 2010
    Posts
    5
    Thanks, that shows the default trace?
    Any query to list the output of all trace been enabled, including custom trace?

    Any idea where does the custom trace settings store, in which table?

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Do you mean trace flags, or profiler trace?

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    select * from sys.traces
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •