sql server removing service_queues

Question

Hi when i query select * from sys.service_queues in sql server 2008 sp3 i am getting

InternalMailQueue
ExternalMailQueue
_LakeSide_DbTools_DeadlockQueue
QueryNotificationErrorsQueue
EventNotificationErrorsQueue
_LakeSide_DbTools_LockQueue
syspolicy_event_queue
ServiceBrokerQueue

i need to remove _LakeSide_DbTools_DeadlockQueue,_LakeSide_DbTools_LockQueue from MSDB database permanently. I intalled that lakesidetool and manually removed all procedures , now stuck in removing this services . I used their uninstall tool doesn't helped. http://www.sqlsolutions.com/products/sql-deadlock-detector/Uninstall.html

Answer 1

If no services refer to the queue, you could simply run a DROP QUEUE statement:

drop queue _LakeSide_DbTools_DeadlockQueue;
go

drop queue _LakeSide_DbTools_LockQueue;
go

BOL reference on DROP QUEUE

Answer 2

Queues are schema bound objects and as such they may belong to a different schema than your current default schema (likely dbo). If that's the case the DROP statement must qualify the queue with a two part name:

DROP QUEUE <schema>.<queue>;

You can get the schema name from sys.service_queues:

SELECT SCHEMA_NAME(schema_id), name FROM sys.service_queues;