sys.remote_service_bindings (Transact-SQL)


Updated: June 10, 2016

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 nameData typeDescription
namesysnameName of this remote service binding. Not NULLABLE.
remote_service_binding_idintID of this remote service binding. Not NULLABLE.
principal_idintID of the database principal that owns this remote service binding. NULLABLE.
remote_service_namenvarchar(256)Name of the remote service that this binding applies to. NULLABLE.
service_contract_idintID 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_idintID 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_onbitThis remote service binding uses ANONYMOUS security. The identity of the user that begins the conversation is not provided to the target service. Not NULLABLE.

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.

Community Additions