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.