Export (0) Print
Expand All
Expand Minimize



Applies To: SQL Server 2014, SQL Server 2016 Preview

Removes a conversation priority from the current database.

Applies to: SQL Server (SQL Server 2008 through current version).

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft