Post reply

Service Broker Queue is getting disabled.

  • February 7, 2013 at 3:15 pm

    #288947

    Hi all.

    Unfortunately I am very new to Service Broker. But our problem is that we have about 20 queues and sometimes one of them is disabled. We have a job that runs every 2 min and enables all the queues. But this queue is getting disabled too often and too quick that the job is not of much a help.

    How can troubleshoot it ? Where to look ? Any help appreciated.

  • February 8, 2013 at 1:09 am

    #1585778

    You can start here http://msdn.microsoft.com/en-us/library/ms166102%28v=sql.100%29.aspx

    1. You should know what cause an activation stored procedures to rollback and return messages to a queue, that cause disable of the queue. You can run the activation procedure in debugger or just in interactive session.

    2. If this error shouldn't cause message to return to the queue you should add handling for this kind of errors in the activation procedure.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply