DROP ENDPOINT (Transact-SQL)

Applies to: SQL Server

Drops an existing endpoint.

Transact-SQL syntax conventions

Syntax

DROP ENDPOINT endPointName  

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

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)