Hello,
I have a Service Broker Queue, which triggers a store procedure to process some data. It all works fine, but I am stuck with one situation. Our QA team, disable the QUEUE manually and enable it again while there is a message in the queue. Afterwards, it does not receive messages also it does not process any. The stored procedure never get triggered. Unless otherwise I recreate the queue, it does not do anything.
What is the best solution to make the queue work again without recreating it.
Any help appreciated.
Sihaab