sys-server-event-session-fields-transact-sql.md

title	sys.server_event_session_fields (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	server_event_session_fields server_event_session_fields_TSQL sys.server_event_session_fields sys.server_event_session_fields_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.server_event_session_fields catalog view xe
ms.assetid	7109f9fb-8a1f-432c-92d1-6f8af3e96af1
author	stevestein
ms.author	sstein

sys.server_event_session_fields (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns a row for each customizable column that was explicitly set on events and targets.

Column name	Data type	Description
event_session_id	int	The ID of the event session. Is not nullable.
object_id	int	The ID of the object this field is associated with. Is not nullable.
name	sysname	The name of the field. Is not nullable.
value	sql_variant	The value of the field. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Remarks

This view has the following relationship cardinalities.

From	To	Relationship
sys.server_event_session_actions.event_session_id	sys.server_event_sessions.event_session_id	Many to one
sys.server_event_session_actions.event_id sys.server_event_session_actions.object_id sys.server_event_session_actions.event_session_id	sys.server_event_session_events.event_session_id sys.server_event_session_events.event_id	Many to one
sys.server_event_session_actions.event_session_id sys.server_event_session_actions.object_id	sys.server_event_session_targets.event_session_id sys.server_event_session_targets.target_id	Many to one

See Also

Catalog Views (Transact-SQL)
Extended Events Catalog Views (Transact-SQL)
Extended Events