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.service
ms.component	t-sql|statements
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	19
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

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;  

See Also

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