Removes a conversation priority from the current database.
Applies to: SQL Server (SQL Server 2008 through current version).
Transact-SQL Syntax Conventions
DROP BROKER PRIORITY 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;