sys-fn-trace-getinfo-transact-sql.md

title	sys.fn_trace_getinfo (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	fn_trace_getinfo fn_trace_getinfo_TSQL
dev_langs	TSQL
helpviewer_keywords	traces [SQL Server], status information status information [SQL Server], traces sys.fn_trace_getinfo function fn_trace_getinfo function
ms.assetid	04b140fe-110a-47b8-98b5-e4c161beb6c9
caps.latest.revision	33
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.fn_trace_getinfo (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Returns information about a specified trace or all existing traces.

IMPORTANT! [!INCLUDEssNoteDepFutureAvoid] Use Extended Events instead.

Transact-SQL Syntax Conventions

Syntax

  
sys.fn_trace_getinfo ( { trace_id | NULL | 0 | DEFAULT } )  

Arguments

trace_id
Is the ID of the trace. trace_id is int. Valid inputs are the ID number of a trace, NULL, 0, or DEFAULT. NULL, 0, and DEFAULT are equivalent values in this context. Specify NULL, 0, or DEFAULT to return information for all traces in the instance of [!INCLUDEssNoVersion].

Tables Returned

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. 0 = stopped. 1 = running.
value	sql_variant	Information about the property of the trace specified.

Remarks

When passed the ID of a specific trace, fn_trace_getinfo returns information about that trace. 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). For similar information about trace filters, see sys.fn_trace_getfilterinfo (Transact-SQL).

For a complete example of using trace stored procedures, see Create a Trace (Transact-SQL).

Permissions

Requires ALTER TRACE permission on the server.

Examples

The following example returns information about all active traces.

SELECT * FROM sys.fn_trace_getinfo(0) ;  
GO  

See Also

Create a Trace (Transact-SQL)
sp_trace_create (Transact-SQL)
sp_trace_generateevent (Transact-SQL)
sp_trace_setevent (Transact-SQL)
sp_trace_setfilter (Transact-SQL)
sp_trace_setstatus (Transact-SQL)
sys.fn_trace_getfilterinfo (Transact-SQL)
sys.fn_trace_geteventinfo (Transact-SQL)
sys.fn_trace_gettable (Transact-SQL)