Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Lists the targets of a trace session.
sp_trace_event_session_targets( [ 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 about all trace event sessions in the database.
A target is the location where the trace event session information is being logged (such as a file or database server message
You must have the MANAGE ANY TRACE SESSION system privilege.
The following statement returns information about all trace event sessions in the database:
SELECT * FROM sp_trace_event_session_targets( );