sys.tcp_endpoints (Transact-SQL)
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. |
See Also
Reference
Catalog Views (Transact-SQL)
Endpoints Catalog Views (Transact-SQL)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|