DROP ENDPOINT (Transact-SQL)

Drops an existing endpoint.

Topic link iconTransact-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)

Other Resources

Sample XML Applications

Help and Information

Getting SQL Server 2005 Assistance