DROP ENDPOINT (Transact-SQL)
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.
For more information, see GRANT Endpoint Permissions (Transact-SQL).
Examples
The following example removes a previously created endpoint called sql_endpoint
.
DROP ENDPOINT sql_endpoint;
See Also
Reference
CREATE ENDPOINT (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
EVENTDATA (Transact-SQL)