Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

DROP BROKER PRIORITY (Transact-SQL)

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;

Community Additions

ADD
Show:
© 2015 Microsoft