Skip to content

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

Latest commit

 

History

History
54 lines (43 loc) · 2.2 KB

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

File metadata and controls

54 lines (43 loc) · 2.2 KB
title sys.server_event_session_targets (Transact-SQL)
description The sys.server_event_session_targets system view returns a row for each event target for an event session.
author rwestMSFT
ms.author randolphwest
ms.date 09/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
server_event_session_targets_TSQL
sys.server_event_session_targets_TSQL
sys.server_event_session_targets
server_event_session_targets
helpviewer_keywords
sys.server_event_session_targets catalog view
xe
dev_langs
TSQL
monikerRange >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

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

[!INCLUDE sssql19-md] and previous versions require VIEW SERVER STATE permission on the server.

[!INCLUDE sssql22-md] and later versions require VIEW SERVER PERFORMANCE 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

Related content