Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version).
Inherits columns from sys.endpoints (Transact-SQL).
Does endpoint support message forwarding. This is initially set to 0 (disabled). Not NULLABLE.
The maximum number of megabytes of tempdb space allowed to be used for messages being forwarded. This is initially set to 10. Not NULLABLE.
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
Description of the type of connection authentication required for connections to this endpoint, one of:
ID of certificate used for authentication, if any.
0 = Windows Authentication is being used.
Encryption algorithm, one of one of the following values:
Encryption algorithm description, one of the following values:
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 and later versions, material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.
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.