This topic has not yet been rated - Rate this topic

sys.server_event_session_fields (Transact-SQL)

SQL Server 2008

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.

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions