drop-event-session-transact-sql.md

title	DROP EVENT SESSION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	DROP_EVENT_SESSION_TSQL DROP EVENT SESSION
dev_langs	TSQL
helpviewer_keywords	event sessions [SQL Server] DROP EVENT SESSION statement
ms.assetid	92eabe4b-24e2-43b1-978c-31a199964b90
author	MightyPen
ms.author	genemi

DROP EVENT SESSION (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Drops an event session.

Transact-SQL Syntax Conventions

Syntax

DROP EVENT SESSION event_session_name  
ON SERVER  

Arguments

event_session_name
Is the name of an existing event session.

Remarks

When you drop an event session, all configuration information, such as targets and session parameters, is completely removed.

Permissions

Requires the ALTER ANY EVENT SESSION permission.

Examples

The following example shows how to drop an event session.

DROP EVENT SESSION evt_spin_lock_diagnosis ON SERVER;
GO

See Also

CREATE EVENT SESSION (Transact-SQL)
ALTER EVENT SESSION (Transact-SQL)
sys.server_event_sessions (Transact-SQL)