Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

fn_trace_getinfo (Transact-SQL)

Updated: 17 July 2006

Returns information about a specified trace or all existing traces.

Topic link icon Transact-SQL Syntax Conventions


fn_trace_getinfo ( trace_id )
trace_id

Is the ID of the trace. trace_id is int.

Column name Data type Description

traceId

int

ID of the trace.

property

int

Property of the trace:

1= Trace options. For more information, see @options in sp_trace_create (Transact-SQL).

2 = File name

3 = Max size

4 = Stop time

5 = Current trace status

value

sql_variant

Information about the property of the trace specified.

When passed the ID of a specific trace, fn_trace_getinfo returns information about that trace. When passed a 0, NULL, or the string 'default', this function returns information about all active traces. When passed an invalid ID, this function returns an empty rowset.

fn_trace_getinfo appends a .trc extension to the name of any trace file included in its result set. For information on defining a trace, see sp_trace_create (Transact-SQL).

Requires ALTER TRACE permission on the server.

Release History

17 July 2006

New content:
  • Added text about the trace file name extension.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.