Export (0) Print
Expand All

sys.server_event_session_fields (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Requires VIEW SERVER STATE permission on the server.

This view has the following relationship cardinalities.

From

To

Relationship

sys.server_event_session_actions.event_session_id

sys.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

Community Additions

ADD
Show:
© 2014 Microsoft