We are trying to launch webservices asynchronously from SQL Server and Service Broker seemed the most interesting choice. For Service Broker itself many different examples can be found online. I managed to have a working example in which I sent several parameters in a message on a queue and have the queue trigger automatically when a message arrives on it.
Tag: service-broker
What is Service Broker in SQL Server?
What is Service Broker in SQL Server and is it meaningful to enable it in a simple database, not in a distributed database? Answer SQL Service Broker is an extension mechanism that allows you to queue events for asynchronous processing. There is no intrinsic harm in enabling the broker. If it’s not used, it will just be idle. It works