Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I query select * from sys.service_queues in SQL Server 2008 sp3, I am getting:


I need to remove _LakeSide_DbTools_DeadlockQueue and _LakeSide_DbTools_LockQueue from MSDB database permanently. I installed that lakesidetool and manually removed all procedures, now stuck in removing this services. I used their uninstall tool, but it didn't help.

share|improve this question

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

drop queue _LakeSide_DbTools_DeadlockQueue;

drop queue _LakeSide_DbTools_LockQueue;

BOL reference on DROP QUEUE

share|improve this answer
No i tried it gives the error, Cannot drop the queue '_LakeSide_DbTools_LockQueue', because it does not exist or you do not have permission. – kumar_2002 Nov 2 '12 at 20:47
How can i drop queue if any services refer to the queue. – kumar_2002 Nov 2 '12 at 20:48

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;
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.