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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sys.server_event_session_targets (Transact-SQL)	sys.server_event_session_targets (Transact-SQL)	rwestMSFT	randolphwest	03/14/2017	sql	system-objects	reference	server_event_session_targets_TSQL sys.server_event_session_targets_TSQL sys.server_event_session_targets server_event_session_targets	sys.server_event_session_targets catalog view xe	TSQL

sys.server_event_session_targets (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

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.

Remarks

This view has the following relationship cardinalities.

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

See Also

Catalog Views (Transact-SQL)
Extended Events Catalog Views (Transact-SQL)
Extended Events