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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho