drop-broker-priority-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
DROP BROKER PRIORITY (Transact-SQL)	DROP BROKER PRIORITY (Transact-SQL)	markingmyname	maghan	03/03/2017	sql	t-sql	reference	DROP_BROKER_PRIORITY_TSQL DROP BROKER PRIORITY	DROP BROKER PRIORITY statement	TSQL

DROP BROKER PRIORITY (Transact-SQL)

[!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

Syntax

DROP BROKER PRIORITY ConversationPriorityName  
[;]  

Arguments

ConversationPriorityName
Specifies the name of the conversation priority to be removed.

Remarks

When you drop a conversation priority, any existing conversations continue to operate with the priority levels they were assigned from the conversation priority.

Permissions

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.

Examples

The following example drops the conversation priority named InitiatorAToTargetPriority.

DROP BROKER PRIORITY InitiatorAToTargetPriority;

See Also

ALTER BROKER PRIORITY (Transact-SQL)
CREATE BROKER PRIORITY (Transact-SQL)
sys.conversation_priorities (Transact-SQL)