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-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	13
author	BYHAM
ms.author	rickbyh
manager	jhubbard

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.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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