December 6, 2012

Endpoints Catalog Views

Se more view version maps here: Microsoft Sql System View Version Maps

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 2005
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
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 2005
SELECT [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 2005
SELECT [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 2005
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
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 2005
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
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 2005
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
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 2005
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
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

Total Pageviews