sys.endpoints (Transact-SQL)
Applies to: 
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. This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. |
| 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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)