Skip to content

Latest commit

 

History

History
50 lines (42 loc) · 2.29 KB

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

File metadata and controls

50 lines (42 loc) · 2.29 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.server_event_session_fields (Transact-SQL)
sys.server_event_session_fields (Transact-SQL)
rwestMSFT
randolphwest
03/14/2017
sql
system-objects
reference
server_event_session_fields
server_event_session_fields_TSQL
sys.server_event_session_fields
sys.server_event_session_fields_TSQL
sys.server_event_session_fields catalog view
xe
TSQL

sys.server_event_session_fields (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

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