sys.server_event_session_targets (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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