| title | sys.endpoints (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.endpoints (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 06/10/2016 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!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)