sp_trace_event_session_events system procedure

sp_trace_event_session_events( [ session_name ] )

session_name Use this optional CHAR(256) parameter to specify the name of the trace event session. The default is NULL. If a session name is not specified or is NULL, information is returned for all trace event sessions.

Column name	Data type	Description
session_name	CHAR(256)	Returns the name of the trace event session.
event_name	CHAR(256)	Returns the trace event name.

Use this system procedure to determine which trace events (both system defined and user defined) are being logged for a trace event session.

You must have the MANAGE ANY TRACE SESSION system privilege.

None

This statement returns information about the events that are part of all the event tracing sessions for the current database:

SELECT * FROM sp_trace_event_session_events( );