sys-remote-service-bindings-transact-sql.md

title	sys.remote_service_bindings (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.remote_service_bindings_TSQL remote_service_bindings_TSQL remote_service_bindings sys.remote_service_bindings
dev_langs	TSQL
helpviewer_keywords	sys.remote_service_bindings catalog view
ms.assetid	4e1a885d-eed1-4993-9c87-e6fd781f437d
caps.latest.revision	20
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.remote_service_bindings (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.