sys.endpoints (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row per endpoint that is created in the system. There is always exactly one SYSTEM endpoint.

Column NameData TypeDescription
namesysnameName of the endpoint. Is unique within the server. Is not nullable.
endpoint_idintID of the endpoint. Is unique within the server. An endpoint with an ID less then 65536 is a system endpoint. Is not nullable.
principal_idintID of the server principal that created and owns this endpoint. Is nullable.
protocoltinyintEndpoint protocol.

1 = HTTP

2 = TCP

3 = Name pipes

4 = Shared memory

5 = Virtual Interface Adapter (VIA)

Is not nullable.
protocol_descnvarchar(60)Description of the endpoint protocol. NULLABLE. One of the following values:





 VIA Note: The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
typetinyintEndpoint payload type.

1 = SOAP

2 = TSQL



Is not nullable.
type_descnvarchar(60)Description of the endpoint payload type. Is nullable. One of the following values:




statetinyintThe endpoint state.

0 = STARTED, listening and processing requests.

1 = STOPPED, listening, but not processing requests.

2 = DISABLED, not listening.

The default state is 1. Is nullable.
state_descnvarchar(60)Description of the endpoint state.

STARTED = Listening and processing requests.

STOPPED = Listening, but not processing requests.

DISABLED = Not listening.

The default state is STOPPED.

Is nullable.
is_admin_endpointbitIndicates whether the endpoint is for administrative use.

0 = Nonadministrative endpoint.

1 = Endpoint is an administrative endpoint.

Is not nullable.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Community Additions