DROP BROKER PRIORITY (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Removes a conversation priority from the current database.

Topic link icon 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)

Community Additions

ADD
Show: