Export (0) Print
Expand All

sys.tcp_endpoints (Transact-SQL)

Updated: 5 December 2005

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 Data type Description

<inherited columns>

Inherits columns from sys.endpoints.

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.

Release History

5 December 2005

New content:
  • Clarified that endpoint information is not used to configure protocols.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft