I need to temporarily stop an activated queue (alter with status = off).
The queue continues to accept rows, but when I start the queue again (alter
with status = on), the queue entries don't get processed.  How do I resume
normal operations so that the queued entries get ...

I need to receive from a queue, parse the data from the queue message_body,
and send the result set from the procedure to a C++ application.  Is there
an easy way to cause the receive command to rollback in the case of an
application error or timeout, or for the receive command ...

When a stored procedure is configured for activation, and if the
max_queue_readers is set to 1, for example, how are activation requests
processed when queue entries arrive faster than they are received?  Are
activation requests also queued, are they event based?  I'm curious ...

(1) where is the actual queue held physically?
(2) my stored proc that the queue uses issues an END CONVERSATION, does the
BEGIN DIALOG also require one? I read that we need 2 END CONVERSATIONS for
it to work correctly

I try to set up the helloworld service broker example from SQL Server on my
computer.  when I ran the example as default, everything is working fine.
but when I try to set up the same example on another database besides
adventurework, it did nothing.  there was nothing send to ...