Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.endpoints (Transact-SQL)

sys.endpoints (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Contains one row per endpoint that is created in the system. There is always exactly one SYSTEM endpoint.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

  • HTTP

  • TCP

  • NAMED_PIPES

  • SHARED_MEMORY

  • VIA

    System_CAPS_noteNote

    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.

NULLABLE.

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.

  • SOAP

  • TSQL

  • SERVICE_BROKER

  • DATABASE_MIRRORING

Is nullable.

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft