Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns a list of the trace event sessions that are defined for the database.
sp_trace_event_sessions( [ session_name ] )
Use this CHAR(256) parameter to specify the trace event session you want to get information about. If a session name
is not specified, information is returned about all trace event sessions in the database.
Start and stop trace event sessions manually by using the STATE clause of the ALTER TRACE EVENT SESSION statement.
You must have the MANAGE ANY TRACE SESSION system privilege.
The following statement returns a list of trace event sessions for the current database:
SELECT * FROM sp_trace_event_sessions( );