sys.remote_service_bindings (Transact-SQL)
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
In SQL Server 2005 and later versions, 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.