sys.service_broker_endpoints (Transact-SQL)

Applies to: SQL Server

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. The following are the possible values with their descriptions and corresponding DDL options. 0 : NONE. Corresponding DDL option: Disabled. 1 : RC4. Corresponding DDL option: {Required | Required algorithm RC4}. 2 : AES. Corresponding DDL option: Required Algorithm AES. 3 : NONE, RC4. Corresponding DDL option: {Supported | Supported Algorithm RC4}. 4 : NONE, AES. Corresponding DDL option: Supported Algorithm AES. 5 : RC4, AES. Corresponding DDL option: Required Algorithm RC4 AES. 6 : AES, RC4. Corresponding DDL option: Required Algorithm AES RC4. 7 : NONE, RC4, AES. Corresponding DDL option: Supported Algorithm RC4 AES. 8 : NONE, AES, RC4. Corresponding DDL option: Supported Algorithm AES RC4. Not NULLABLE.
encryption_algorithm_desc	nvarchar(60)	Encryption algorithm description. The possible values and their corresponding DDL options are listed below: 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 (11.x) and later versions, 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 was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

ALTER ENDPOINT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)