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.