Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns information about the trace events in the database.
sp_trace_events( [ event_name ] )
Use this optional CHAR(256) parameter to specify the trace event name. The default is NULL.
This procedure returns information about both system-defined and user-defined trace events in the database. It returns the
details for the specified trace event or for all trace events if event_name is not supplied or is NULL.
You must have the MANAGE ANY TRACE SESSION system privilege.
The following statement returns a list of user-defined trace events in the database:
SELECT * FROM sp_trace_events( )
WHERE is_system = 0;