| title | DROP BROKER PRIORITY (Transact-SQL) | ||
|---|---|---|---|
| description | DROP BROKER PRIORITY (Transact-SQL) | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.date | 03/03/2017 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Removes a conversation priority from the current database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DROP BROKER PRIORITY ConversationPriorityName
[;]
ConversationPriorityName
Specifies the name of the conversation priority to be removed.
When you drop a conversation priority, any existing conversations continue to operate with the priority levels they were assigned from the conversation priority.
Permission for creating a conversation priority defaults to members of the db_ddladmin or db_owner fixed database roles, and to the sysadmin fixed server role. Requires ALTER permission on the database.
The following example drops the conversation priority named InitiatorAToTargetPriority.
DROP BROKER PRIORITY InitiatorAToTargetPriority;ALTER BROKER PRIORITY (Transact-SQL)
CREATE BROKER PRIORITY (Transact-SQL)
sys.conversation_priorities (Transact-SQL)