title: Should a procedure from message queue activation set on a loop?
body: <p>I'm trying to start using SQL Server Service Broker to audit asynchronous what the users of a intranet application are doing.</p>
  
  <p>I've create the message, contract, queue and service. Set up a procedure to fire on activation of this queue.</p>
  
  <p>So far, so good. Messages are being sent and received.</p>
  
  <p>The procedure receives the Top 1 message from that queue and does what it need to do (basically an insert into a table) and exits.</p>
  
  <p><b>My question:</b> does the procedure that receives the message need to be on infinite loop? The <code>MAX_QUEUE_READERS</code> setting of the Queue is 2. Does that mean that always will be 2 instances of the procedure running, regardless of the number of messages in the queue?</p>