This topic has not yet been rated - Rate this topic

sys.server_event_session_targets (Transact-SQL)

SQL Server 2008 R2

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions