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. |