sys.server_event_session_targets (Transact-SQL)

Returns a row for each event target for an event session.

Column name	Data type	Description
event_session_id	int	The ID of the event session. Is not nullable.
target_id	int	The ID of the target. ID is unique within the event session object. Is not nullable.
name	sysname	The name of the event target. Is not nullable.
package	sysname	The name of the event package that contains the event target. Is not nullable.
module	sysname	The name of the module that contains the event target. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

This view has the following relationship cardinalities.

From	To	Relationship
sys.server_event_session_targets.event_session_id	sys.sys.server_event_sessions.event_session_id	Many to one