sys.remote_service_bindings (Transact-SQL)

Applies to: SQL Server

This catalog view contains a row per remote service binding.

Column name	Data type	Description
name	sysname	Name of this remote service binding. Not NULLABLE.
remote_service_binding_id	int	ID of this remote service binding. Not NULLABLE.
principal_id	int	ID of the database principal that owns this remote service binding. NULLABLE.
remote_service_name	nvarchar(256)	Name of the remote service that this binding applies to. NULLABLE.
service_contract_id	int	ID of the contract that this binding applies to. A value of 0 is a wildcard that means this binding applies to all contracts for the service. Not NULLABLE.
remote_principal_id	int	ID for the user specified in the remote service binding. Service Broker uses a certificate owned by this user for communicating with the specified service on the specified contracts. NULLABLE.
is_anonymous_on	bit	This remote service binding uses ANONYMOUS security. The identity of the user that begins the conversation is not provided to the target service. Not NULLABLE.

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.