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

title	sys.server_event_session_targets (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	server_event_session_targets_TSQL sys.server_event_session_targets_TSQL sys.server_event_session_targets server_event_session_targets
dev_langs	TSQL
helpviewer_keywords	sys.server_event_session_targets catalog view xe
ms.assetid	dda4879d-57ae-4267-b410-1ef5c37404c7
author	stevestein
ms.author	sstein

sys.server_event_session_targets (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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