I am looking at a new application and using SQL Server's Service Broker seems to be a good fit for it. I'm very experienced with SQL Server, but brand new to Service Broker. I am looking at using a queue with an Internal Activation stored procedure, as found here (Creating an Internal Activation Procedure)
From my understanding and experimentation, once a message hit the queue, the stored procedure is called, but why do a number of examples then use WAITFOR ... TIMEOUT? What would I be waiting for if this is an activation procedure? Wouldn't the message be in the queue already waiting to be received?