Export (0) Print
Expand All

sys.server_event_session_targets (Transact-SQL)

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.

Requires VIEW SERVER STATE permission on the server.

This view has the following relationship cardinalities.

From

To

Relationship

sys.server_event_session_targets.event_session_id

sys.sys.server_event_sessions.event_session_id

Many to one

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft