title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.conversation_priorities (Transact-SQL) |
sys.conversation_priorities (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
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;
ALTER BROKER PRIORITY (Transact-SQL)
CREATE BROKER PRIORITY (Transact-SQL)
DROP BROKER PRIORITY (Transact-SQL)
sys.services (Transact-SQL)
sys.service_contracts (Transact-SQL)