Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers

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
add comment

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

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
add comment

Your Answer

 
discard

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.