Post reply

how to tell if a trace is running on a database

  • March 20, 2006 at 8:44 am

    #112396

    how do i tell if a trace is running on a DB, or how many traces are running and their filter parameters?

  • March 21, 2006 at 6:15 am

    #627840

    SELECT *

    FROM ::fn_trace_getinfo(default)

    From Books on Line:

    Tables Returned

    If a trace_id is specified, fn_trace_getinfo returns a table with information about the specified trace. If no trace_id is specified, this function returns information about all active traces.

    Column name Data type Description
    TraceId int The ID of the trace.
    Property int The property of the trace as represented by the following integers:

    1 - Trace Options (See @options in sp_trace_create)

    2 - FileName

    3 - MaxSize

    4 - StopTime

    5 - Current Trace status
    Value sql_variant The information about the property of the trace specified.

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

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