SQL BROKER Queue disabled

Question

Hi,

     I am new to sql broker service. I developed an application using sql broker .The problem that i am facing is that the queue is disabled. Initially i thought its poison message. so i ended conversation and cleaned the queue. I also enabled disabled queue , but its still showing queue disabled. any help greatly appreciated.

Answer 1

Queue get disabled if it receive 5 invalid messages. best way to troubleshoot this is, stop the service that is sending message to this queue, clear all messages then send a very basic massage to see the status remain enabled or not, 

see this link

http://www.sqlteam.com/article/how-to-troubleshoot-service-broker-problems

vt 

---

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker