drop-endpoint-transact-sql.md

title	DROP ENDPOINT (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP_ENDPOINT_TSQL DROP ENDPOINT
dev_langs	TSQL
helpviewer_keywords	removing endpoints endpoints [SQL Server], removing deleting endpoints DROP ENDPOINT statement dropping endpoints
ms.assetid	6aca7412-66a5-4fa4-86b2-061512ff2080
caps.latest.revision	32
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

DROP ENDPOINT (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Drops an existing endpoint.

Transact-SQL Syntax Conventions

Syntax

  
DROP ENDPOINT endPointName  

Arguments

endPointName
Is the name of the endpoint to be removed.

Remarks

The ENDPOINT DDL statements cannot be executed inside a user transaction.

Permissions

User must be a member of the sysadmin fixed server role, the owner of the endpoint, or have been granted CONTROL permission on the endpoint.

Examples

The following example removes a previously created endpoint called sql_endpoint.

DROP ENDPOINT sql_endpoint;  

See Also

CREATE ENDPOINT (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
EVENTDATA (Transact-SQL)