TechNet
Export (0) Print
Expand All

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:

 HTTP

 TCP

 NAMED_PIPES

 SHARED_MEMORY

 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

3 = SERVICE_BROKER

4 = DATABASE_MIRRORING

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

 SOAP

 TSQL

 SERVICE_BROKER

 DATABASE_MIRRORING
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

ADD
Show:
© 2016 Microsoft