sys.server_event_session_fields (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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

SQL Server 2019 (15.x) and previous versions require VIEW SERVER STATE permission on the server.

SQL Server 2022 (16.x) and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.

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

Var denne side nyttig?