sys.service_broker_endpoints (Transact-SQL)
This catalog view contains one row for the Service Broker endpoint. For every row in this view, there is a corresponding row with the same endpoint_id in the sys.tcp_endpoints view that contains the TCP configuration metadata. TCP is the only allowed protocol for Service Broker.
Column name |
Data type |
Description |
||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
<inherited columns> |
-- |
Inherits columns from sys.endpoints (Transact-SQL). |
||||||||||||||||||||||||||||||
is_message_forwarding_enabled |
bit |
Does endpoint support message forwarding. This is initially set to 0 (disabled). Not NULLABLE. |
||||||||||||||||||||||||||||||
message_forwarding_size |
int |
The maximum number of megabytes of tempdb space allowed to be used for messages being forwarded. This is initially set to 10. Not NULLABLE. |
||||||||||||||||||||||||||||||
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 Not NULLABLE. |
||||||||||||||||||||||||||||||
connection_auth_desc |
nvarchar(60) |
Description of the type of connection authentication required for connections to this endpoint, one of:
NULLABLE. |
||||||||||||||||||||||||||||||
certificate_id |
int |
ID of certificate used for authentication, if any. 0 = Windows Authentication is being used. |
||||||||||||||||||||||||||||||
encryption_algorithm |
tinyint |
Encryption algorithm, one of one of the following values:
Not NULLABLE. |
||||||||||||||||||||||||||||||
encryption_algorithm_desc |
nvarchar(60) |
Encryption algorithm description, one of the following values:
NULLABLE. |
Remarks
Note
The RC4 algorithm is only supported for backward compatibility. New material can only be encrypted using RC4 or RC4_128 when the database is in compatibility level 90 or 100. (Not recommended.) Use a newer algorithm such as one of the AES algorithms instead. In SQL Server 2012 material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.
Permissions
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.