- sys.database_mirroring_endpoints
- sys.endpoint_webmethods
- sys.endpoints
- sys.http_endpoints
- sys.soap_endpoints
- sys.tcp_endpoints
- sys.via_endpoints
sys.database_mirroring_endpoints
Contains one row for the database mirroring endpoint of an instance of SQL Server 2012. Note The database mirroring endpoint supports both sessions between database mirroring partners and with witnesses and sessions between the primary replica of a AlwaysOn availability group and its secondary replicas.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Inherited From | Description |
|---|---|---|---|---|---|---|---|
| name | • | • | • | • | sysname | sys.endpoints | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | • | • | • | • | int | sys.endpoints | 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 | sys.endpoints | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | • | • | • | • | tinyint | sys.endpoints | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint protocol. HTTP TCP NAMED_PIPES SHARED_MEMORY VIA NULLABLE. |
| type | • | • | • | • | tinyint | sys.endpoints | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint payload type. SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING Is nullable. |
| state | • | • | • | • | tinyint | sys.endpoints | 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) | sys.endpoints | 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 | sys.endpoints | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
| role | • | • | • | • | tinyint | Mirroring role, one of: 0 = None 1 = Partner 2 = Witness 3 = All |
|
| role_desc | • | • | • | • | nvarchar(60) | Description of mirroring role, one of: NONE PARTNER WITNESS ALL |
|
| is_encryption_enabled | • | • | • | • | bit | 1 means that encryption is enabled. 0 means that encryption is disabled. |
|
| connection_auth | • | • | • | • | tinyint | The type of connection authentication required for connections to this endpoint, one of: 1 - NTLM 2 - KERBEROS 3 - NEGOTIATE 4 - CERTIFICATE 5 - NTLM, CERTIFICATE 6 - KERBEROS, CERTIFICATE 7 - NEGOTIATE, CERTIFICATE 8 - CERTIFICATE, NTLM 9 - CERTIFICATE, KERBEROS 10 - CERTIFICATE, NEGOTIATE |
|
| connection_auth_desc | • | • | • | • | Nvarchar (60) | Description of the type of authentication required for connections to this endpoint, one of: NTLM KERBEROS NEGOTIATE CERTIFICATE NTLM, CERTIFICATE KERBEROS, CERTIFICATE NEGOTIATE, CERTIFICATE CERTIFICATE, NTLM CERTIFICATE, KERBEROS CERTIFICATE, NEGOTIATE |
|
| certificate_id | • | • | • | • | int | ID of certificate used for authentication, if any. NULL = Windows Authentication is being used. |
|
| encryption_algorithm | • | • | • | • | tinyint | Encryption algorithm, one of: 0 €“ NONE 1 €“ RC4 2 €“ AES 3 €“ NONE, RC4 4 €“ NONE, AES 5 €“ RC4, AES 6 €“ AES, RC4 7 €“ NONE, RC4, AES 8 €“ NONE, AES, RC4 |
|
| encryption_algorithm_desc | • | • | • | • | nvarchar(60) | Description of the encryption algorithm, one of: NONE RC4 AES NONE, RC4 NONE, AES RC4, AES AES, RC4 NONE, RC4, AES NONE, AES, RC4 |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [role], [role_desc], [is_encryption_enabled], [connection_auth], [connection_auth_desc], [certificate_id], [encryption_algorithm], [encryption_algorithm_desc] FROM sys.database_mirroring_endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [role], [role_desc], [is_encryption_enabled], [connection_auth], [connection_auth_desc], [certificate_id], [encryption_algorithm], [encryption_algorithm_desc] FROM sys.database_mirroring_endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [role], [role_desc], [is_encryption_enabled], [connection_auth], [connection_auth_desc], [certificate_id], [encryption_algorithm], [encryption_algorithm_desc] FROM sys.database_mirroring_endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [role], [role_desc], [is_encryption_enabled], [connection_auth], [connection_auth_desc], [certificate_id], [encryption_algorithm], [encryption_algorithm_desc] FROM sys.database_mirroring_endpoints
Back to Top
sys.endpoint_webmethods
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. Contains a row FOR EACH SOAP method defined on a SOAP-enabled HTTP endpoint. The combination of the endpoint_id and namespace columns is unique.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Description |
|---|---|---|---|---|---|---|
| endpoint_id | • | • | • | • | int | ID of the endpoint that the webmethod is defined on. |
| namespace | • | • | • | • | nvarchar(384) | Namespace for the webmethod. |
| method_alias | • | • | • | • | nvarchar(64) | Alias for the method. Note: Transact-SQL identifiers allow characters that are not legal in WSDL method names. The alias is used to map the name exposed in the WSDL description of the endpoint to the actual underlying Transact-SQL executable object that is called when the webmethod is invoked. |
| object_name | • | • | • | • | nvarchar(776) | The object name that the webmethod is redirected to, as specified in the NAME = option. Name parts are separated by a period (.), and delimited using brackets, [ ]. The object name must be a three-part name, as specified in the WSDL option. |
| result_schema | • | • | • | • | tinyint | Option that determines which, if any, XSD is sent back with a response. 0 = None 1 = Standard 2 = Default |
| result_schema_desc | • | • | • | • | nvarchar(60) | Description of option that determines which, if any, XSD is sent back with a response. NONE STANDARD DEFAULT |
| result_format | • | • | • | • | tinyint | Option that determines how results are formatted in the response. 1 = ALL_RESULTS 2 = ROWSETS_ONLY 3 = NONE |
| result_format_desc | • | • | • | • | nvarchar(60) | Description of the option that determines how results are formatted in the response. ALL_RESULTS ROWSETS_ONLY NONE |
TSQL
Sql 2005SELECT [endpoint_id], [namespace], [method_alias], [object_name], [result_schema], [result_schema_desc], [result_format], [result_format_desc] FROM sys.endpoint_webmethods
Sql 2008
SELECT [endpoint_id], [namespace], [method_alias], [object_name], [result_schema], [result_schema_desc], [result_format], [result_format_desc] FROM sys.endpoint_webmethods
Sql 2008 R2
SELECT [endpoint_id], [namespace], [method_alias], [object_name], [result_schema], [result_schema_desc], [result_format], [result_format_desc] FROM sys.endpoint_webmethods
Sql 2012
SELECT [endpoint_id], [namespace], [method_alias], [object_name], [result_schema], [result_schema_desc], [result_format], [result_format_desc] FROM sys.endpoint_webmethods
Back to Top
sys.endpoints
endpoint that is created in the system. There is always exactly one SYSTEM endpoint.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | 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 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. |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint] FROM sys.endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint] FROM sys.endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint] FROM sys.endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint] FROM sys.endpoints
Back to Top
sys.http_endpoints
endpoint created in the server that uses the HTTP protocol.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Inherited From | Description |
|---|---|---|---|---|---|---|---|
| name | • | • | • | • | sysname | sys.endpoints | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | • | • | • | • | int | sys.endpoints | 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 | sys.endpoints | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | • | • | • | • | tinyint | sys.endpoints | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint protocol. HTTP TCP NAMED_PIPES SHARED_MEMORY VIA NULLABLE. |
| type | • | • | • | • | tinyint | sys.endpoints | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint payload type. SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING Is nullable. |
| state | • | • | • | • | tinyint | sys.endpoints | 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) | sys.endpoints | 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 | sys.endpoints | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
| site | • | • | • | • | nvarchar(128) | Name of the host computer for the site, as specified in the SITE = option. | |
| url_path | • | • | • | • | nvarchar(4000) | Path-only portion of the URL for this HTTP endpoint, as specified by the PATH= option. | |
| is_clear_port_enabled | • | • | • | • | bit | 1 = Clear port is enabled using the PORT = CLEAR option. | |
| clear_port | • | • | • | • | int | Port number specified in the CLEAR PORT = option. NULL = Not specified. |
|
| is_ssl_port_enabled | • | • | • | • | bit | 1 = SSL port is enabled using the PORT = SSL option. | |
| ssl_port | • | • | • | • | int | Port number value specified in the SSL PORT = option. NULL = Not specified. |
|
| is_anonymous_enabled | • | • | • | • | bit | 1 = Anonymous access is enabled using the AUTHENTICATION = ANONYMOUS option. | |
| is_basic_auth_enabled | • | • | • | • | bit | 1 = Basic authentication is enabled using the AUTHENTICATION = BASIC option. | |
| is_digest_auth_enabled | • | • | • | • | bit | 1 = Digest authentication is enabled using the AUTHENTICATION = DIGEST option. | |
| is_kerberos_auth_enabled | • | • | • | • | bit | 1 = Integrated authentication enabled using the AUTHENTICATION = KERBEROS option. | |
| is_ntlm_auth_enabled | • | • | • | • | bit | 1 = Integrated authentication enabled using the AUTHENTICATION = NTLM option. | |
| is_integrated_auth_enabled | • | • | • | • | bit | 1 = Integrated authentication is enabled using the AUTHENTICATION = INTEGRATED option. | |
| authorization_realm | • | • | • | • | nvarchar(128) | Hint that is returned to the client as part of the HTTP DIGEST authentication challenge. The value of the AUTH REALM option. Is NULL if not specified or if DIGEST authentication is not enabled. |
|
| default_logon_domain | • | • | • | • | nvarchar(128) | Default login domain if you enable BASIC authentication. The value of the DEFAULT LOGON DOMAIN option. Is NULL if not specified or if BASIC authentication is not enabled. |
|
| is_compression_enabled | • | • | • | • | bit | 1 = COMPRESSION = ENABLED option is set. |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [site], [url_path], [is_clear_port_enabled], [clear_port], [is_ssl_port_enabled], [ssl_port], [is_anonymous_enabled], [is_basic_auth_enabled], [is_digest_auth_enabled], [is_kerberos_auth_enabled], [is_ntlm_auth_enabled], [is_integrated_auth_enabled], [authorization_realm], [default_logon_domain], [is_compression_enabled] FROM sys.http_endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [site], [url_path], [is_clear_port_enabled], [clear_port], [is_ssl_port_enabled], [ssl_port], [is_anonymous_enabled], [is_basic_auth_enabled], [is_digest_auth_enabled], [is_kerberos_auth_enabled], [is_ntlm_auth_enabled], [is_integrated_auth_enabled], [authorization_realm], [default_logon_domain], [is_compression_enabled] FROM sys.http_endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [site], [url_path], [is_clear_port_enabled], [clear_port], [is_ssl_port_enabled], [ssl_port], [is_anonymous_enabled], [is_basic_auth_enabled], [is_digest_auth_enabled], [is_kerberos_auth_enabled], [is_ntlm_auth_enabled], [is_integrated_auth_enabled], [authorization_realm], [default_logon_domain], [is_compression_enabled] FROM sys.http_endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [site], [url_path], [is_clear_port_enabled], [clear_port], [is_ssl_port_enabled], [ssl_port], [is_anonymous_enabled], [is_basic_auth_enabled], [is_digest_auth_enabled], [is_kerberos_auth_enabled], [is_ntlm_auth_enabled], [is_integrated_auth_enabled], [authorization_realm], [default_logon_domain], [is_compression_enabled] FROM sys.http_endpoints
Back to Top
sys.soap_endpoints
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. Contains one row for each endpoint in the server that carries a SOAP-type payload. For every row in this view, there is a corresponding row with the same endpoint_id in the sys.http_endpoints catalog view that carries the HTTP configuration metadata.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Inherited From | Description |
|---|---|---|---|---|---|---|---|
| name | • | • | • | • | sysname | sys.endpoints | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | • | • | • | • | int | sys.endpoints | 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 | sys.endpoints | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | • | • | • | • | tinyint | sys.endpoints | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint protocol. HTTP TCP NAMED_PIPES SHARED_MEMORY VIA NULLABLE. |
| type | • | • | • | • | tinyint | sys.endpoints | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint payload type. SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING Is nullable. |
| state | • | • | • | • | tinyint | sys.endpoints | 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) | sys.endpoints | 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 | sys.endpoints | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
| is_sql_language_enabled | • | • | • | • | bit | 1 = BATCHES = ENABLED option was specified, meaning that ad-hoc SQL batches are allowed on the endpoint. | |
| wsdl_generator_procedure | • | • | • | • | nvarchar(776) | The three-part name of the stored procedure that implements this method. Names of methods require strict three-part syntax. one, two, or four-part names are not allowed. |
|
| default_database | • | • | • | • | sysname | The name of the default database given in the DATABASE = option. NULL = DEFAULT was specified. |
|
| default_namespace | • | • | • | • | nvarchar(384) | The default namespace specified in the NAMESPACE = option, or 'http://tempuri.org' if DEFAULT was specified instead. | |
| default_result_schema | • | • | • | • | tinyint | The default value of the SCHEMA = option. 0 = NONE 1 = STANDARD |
|
| default_result_schema_desc | • | • | • | • | nvarchar(60) | Description of the default value of the SCHEMA = option. NONE STANDARD |
|
| is_xml_charset_enforced | • | • | • | • | bit | 0 = CHARACTER_SET = SQL option was specified. 1 = CHARACTER_SET = XML option was specified. |
|
| is_session_enabled | • | • | • | • | bit | 0 = SESSION = DISABLE option was specified. 1 = SESSION = ENABLED option was specified. |
|
| session_timeout | • | • | • | • | int | Value specified in SESSION_TIMEOUT = option. | |
| login_type | • | • | • | • | nvarchar(60) | Kind of authentication allowed on this endpoint. WINDOWS MIXED |
|
| header_limit | • | • | • | • | int | Maximum allowable size of the SOAP header. |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [is_sql_language_enabled], [wsdl_generator_procedure], [default_database], [default_namespace], [default_result_schema], [default_result_schema_desc], [is_xml_charset_enforced], [is_session_enabled], [session_timeout], [login_type], [header_limit] FROM sys.soap_endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [is_sql_language_enabled], [wsdl_generator_procedure], [default_database], [default_namespace], [default_result_schema], [default_result_schema_desc], [is_xml_charset_enforced], [is_session_enabled], [session_timeout], [login_type], [header_limit] FROM sys.soap_endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [is_sql_language_enabled], [wsdl_generator_procedure], [default_database], [default_namespace], [default_result_schema], [default_result_schema_desc], [is_xml_charset_enforced], [is_session_enabled], [session_timeout], [login_type], [header_limit] FROM sys.soap_endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [is_sql_language_enabled], [wsdl_generator_procedure], [default_database], [default_namespace], [default_result_schema], [default_result_schema_desc], [is_xml_charset_enforced], [is_session_enabled], [session_timeout], [login_type], [header_limit] FROM sys.soap_endpoints
Back to Top
sys.tcp_endpoints
Contains one row for each TCP endpoint that is in the system. The endpoints that are described by sys.tcp_endpoints provide an object to grant and revoke the connection privilege. The information that is displayed regarding ports and IP addresses is not used to configure the protocols and may not match the actual protocol configuration. To view and configure protocols, use SQL Server Configuration Manager.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Inherited From | Description |
|---|---|---|---|---|---|---|---|
| name | • | • | • | • | sysname | sys.endpoints | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | • | • | • | • | int | sys.endpoints | 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 | sys.endpoints | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | • | • | • | • | tinyint | sys.endpoints | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint protocol. HTTP TCP NAMED_PIPES SHARED_MEMORY VIA NULLABLE. |
| type | • | • | • | • | tinyint | sys.endpoints | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint payload type. SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING Is nullable. |
| state | • | • | • | • | tinyint | sys.endpoints | 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) | sys.endpoints | 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 | sys.endpoints | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
| port | • | • | • | • | int | The port number that the endpoint is listening on. Is not nullable. | |
| is_dynamic_port | • | • | • | • | bit | 1 = Port number was dynamically assigned. Is not nullable. |
|
| ip_address | • | • | • | • | nvarchar(45) | Listener IP address as specified by the LISTENER_IP clause. Is nullable. |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [port], [is_dynamic_port], [ip_address] FROM sys.tcp_endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [port], [is_dynamic_port], [ip_address] FROM sys.tcp_endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [port], [is_dynamic_port], [ip_address] FROM sys.tcp_endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [port], [is_dynamic_port], [ip_address] FROM sys.tcp_endpoints
Back to Top
sys.via_endpoints
Virtual Interface Adapter (VIA) endpoint in the system.
| Column name | Sql 2005 | Sql 2008 | Sql 2008 R2 | Sql 2012 | Type | Inherited From | Description |
|---|---|---|---|---|---|---|---|
| name | • | • | • | • | sysname | sys.endpoints | Name of the endpoint. Is unique within the server. Is not nullable. |
| endpoint_id | • | • | • | • | int | sys.endpoints | 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 | sys.endpoints | ID of the server principal that created and owns this endpoint. Is nullable. |
| protocol | • | • | • | • | tinyint | sys.endpoints | Endpoint protocol. 1 = HTTP 2 = TCP 3 = Name pipes 4 = Shared memory 5 = Virtual Interface Adapter (VIA) Is not nullable. |
| protocol_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint protocol. HTTP TCP NAMED_PIPES SHARED_MEMORY VIA NULLABLE. |
| type | • | • | • | • | tinyint | sys.endpoints | Endpoint payload type. 1 = SOAP 2 = TSQL 3 = SERVICE_BROKER 4 = DATABASE_MIRRORING Is not nullable. |
| type_desc | • | • | • | • | nvarchar(60) | sys.endpoints | Description of the endpoint payload type. SOAP TSQL SERVICE_BROKER DATABASE_MIRRORING Is nullable. |
| state | • | • | • | • | tinyint | sys.endpoints | 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) | sys.endpoints | 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 | sys.endpoints | Indicates whether the endpoint is for administrative use. 0 = Nonadministrative endpoint. 1 = Endpoint is an administrative endpoint. Is not nullable. |
| discriminator | • | • | • | • | nvarchar(128) | Unique value that is the port discriminator. |
TSQL
Sql 2005SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [discriminator] FROM sys.via_endpoints
Sql 2008
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [discriminator] FROM sys.via_endpoints
Sql 2008 R2
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [discriminator] FROM sys.via_endpoints
Sql 2012
SELECT [name], [endpoint_id], [principal_id], [protocol], [protocol_desc], [type], [type_desc], [state], [state_desc], [is_admin_endpoint], [discriminator] FROM sys.via_endpoints
Back to Top
No comments:
Post a Comment