SQL Server Service Broker – Internal Activation

SQL Server Service Broker allows you to create activation stored procedures, which are called automatically (by Service Broker - Queue Monitor) whenever a message arrives in the queue (very much like a trigger but not exactly the same). Not only this, you can specify the number of instances of the stored procedure to be created to process messages from different conversation groups in parallel if the queue is overloaded with the arrival of lots of messages. In this article, I will be talking about setting up internal activation and writing a stored procedure, which will be called on activation, for more information click here.