sys-conversation-priorities-transact-sql.md

title	sys.conversation_priorities (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	conversation_priorities_TSQL conversation_priorities sys.conversation_priorities_TSQL sys.conversation_priorities
dev_langs	TSQL
helpviewer_keywords	conversations [Service Broker], priorities Service Broker, conversations sys.conversation_priorities catalog view
ms.assetid	7cbb9171-3310-4aae-8458-755c882d6462
author	stevestein
ms.author	sstein

sys.conversation_priorities (Transact-SQL)

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

Contains a row for each conversation priority created in the current database, as shown in the following table:

Column name	Data type	Description
Priority_id	int	A number that uniquely identifies the conversation priority. Not NULLABLE.
name	sysname	Name of the conversation priority. Not NULLABLE.
service_contract_id	int	The identifier of the contract that is specified for the conversation priority. This can be joined on the service_contract_id column in sys.service_contracts. NULLABLE.
local_service_id	int	The identifier of the service that is specified as the local service for the conversation priority. This column can be joined on the service_id column in sys.services. NULLABLE.
remote_service_name	nvarchar(256)	The name of the service that is specified as the remote service for the conversation priority. NULLABLE.
priority	tinyint	The priority level that is specified in this conversation priority. Not NULLABLE.

Permissions

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

Examples

The following example lists the conversation priorities by using joins to show the contract and local service names.

SELECT scp.name AS priority_name,  
       ssc.name AS contract_name,  
       ssvc.name AS local_service_name,  
       scp.remote_service_name,  
       scp.priority AS priority_level  
FROM sys.conversation_priorities AS scp  
    INNER JOIN sys.service_contracts AS ssc  
       ON scp.service_contract_id = ssc.service_contract_id  
    INNER JOIN sys.services AS ssvc  
       ON scp.local_service_id = ssvc.service_id  
ORDER BY priority_name, contract_name,  
         local_service_name, remote_service_name;  
  

See Also

ALTER BROKER PRIORITY (Transact-SQL)
CREATE BROKER PRIORITY (Transact-SQL)
DROP BROKER PRIORITY (Transact-SQL)
sys.services (Transact-SQL)
sys.service_contracts (Transact-SQL)