Service Broker and External Activation
The activation mechanism in SQL Server 2005 Service Broker is tied to only stored procedures. What this means is, each time a message arrives in the queue, a stored procedure can handle the message and act upon it. However, what if you want an external program to be launched for the queue message? This is called external activation and there is no easy way to do this for now. However, a workaround exists by using the event notification features of SQL Server 2005. Check
this blog from Rushi Desai for how to do this along with a downloadable sample.