Service Broker: Asynchronous Web Service Calls From SQL Database

added by sergeymaskalik
6/25/2012 1:17:34 PM

7 Kicks, 997 Views

There are times when you have no choice but to use SQL triggers to execute a long running process or call a web service. Since triggers are doing implicit locks it could cause table locking and scalability problems. This article shows how SQL Server Service broker can gracefully solve this problem by using asynchronous triggers which use message queues and then offloading of calling web services to the application outside of SQL Server.


1 comments

vblain
6/25/2012 1:25:33 PM
Finally a proper walk through on SQL Service Broker. Thank you so much for all the hard work.