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: NTLM KERBEROS NEGOTIATE CERTIFICATE NTLM, CERTIFICATE KERBEROS, CERTIFICATE NEGOTIATE, CERTIFICATE CERTIFICATE, NTLM CERTIFICATE, KERBEROS CERTIFICATE, NEGOTIATE 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: Value Description Corresponding DDL option 0 NONE Disabled 1 RC4 {Required | Required algorithm RC4} 2 AES Required Algorithm AES 3 NONE, RC4 {Supported | Supported Algorithm RC4} 4 NONE, AES Supported Algorithm AES 5 RC4, AES Required Algorithm RC4 AES 6 AES, RC4 Required Algorithm AES RC4 7 NONE, RC4, AES Supported Algorithm RC4 AES 8 NONE, AES, RC4 Supported Algorithm AES RC4 Not NULLABLE.
encryption_algorithm_desc	nvarchar(60)	Encryption algorithm description, one of the following values: Value Corresponding DDL option NONE Disabled RC4 {Required | Required Algorithm RC4} AES Required Algorithm AES NONE, RC4 {Supported | Supported Algorithm RC4} NONE, AES Supported Algorithm AES RC4, AES Required Algorithm RC4 AES AES, RC4 Required Algorithm AES RC4 NONE, RC4, AES Supported Algorithm RC4 AES NONE, AES, RC4 Supported Algorithm AES RC4 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.

See Also

Reference

ALTER ENDPOINT (Transact-SQL)

CREATE ENDPOINT (Transact-SQL)