Updated: June 10, 2016
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.|
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.