none
SQL BROKER Queue disabled

    Pertanyaan

  • 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.

    16 Oktober 2011 8:41

Jawaban

  • 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
    • Ditandai sebagai Jawaban oleh KJian_ 24 Oktober 2011 6:11
    16 Oktober 2011 14:43