DROP TRACE EVENT SESSION [ IF EXISTS ] session-name UNCONDITIONALLY

When UNCONDITIONALLY is specified, dropping an active session automatically stops the session before removing its definition. Otherwise, an error is returned.

You must have the MANAGE ANY TRACE SESSION system privilege.

None

• Event tracing
• CREATE TEMPORARY TRACE EVENT statement
• CREATE TEMPORARY TRACE EVENT SESSION statement
• ALTER TRACE EVENT SESSION statement
• DROP TRACE EVENT SESSION statement
• NOTIFY TRACE EVENT statement
• sp_trace_events system procedure
• sp_trace_event_fields system procedure
• sp_trace_event_sessions system procedure
• sp_trace_event_session_events system procedure
• sp_trace_event_session_targets system procedure
• sp_trace_event_session_target_options system procedure
• Event Trace Data (ETD) File Management utility (dbmanageetd)
• System events

The following statement drops the trace event session named my_session:

DROP TRACE EVENT SESSION my_session;