sys.remote_service_bindings (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 has been granted some permission. For more information, see Metadata Visibility Configuration.