| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.endpoints (Transact-SQL) |
sys.endpoints (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Contains one row per endpoint that is created in the system. There is always exactly one SYSTEM endpoint.
| Column Name | Data Type | Description |
|---|---|---|
| name | sysname | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | int | ID of the endpoint. Is unique within the server. An endpoint with an ID less then 65536 is a system endpoint. Is not nullable. |
| principal_id | int | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | tinyint | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | nvarchar(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. [!INCLUDEssNoteDepFutureAvoid] |
| type | tinyint | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | nvarchar(60) | Description of the endpoint payload type. Is nullable. One of the following values: SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING |
| state | tinyint | The 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_desc | nvarchar(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_endpoint | bit | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)