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 nameData typeDescription
    TraceIdintThe ID of the trace.
    PropertyintThe 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

    Valuesql_variantThe 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