Udostępnij za pośrednictwem


Runaway SQL Server Service Broker Activation Script

I have been experimenting with using the SQL Server Service Broker in my latest project. We had a long running SQL process that needed to be executed in the background and the Service Broker sounded like a good choice. I found some good articles on how to set this up and had success quickly. After some simple examples I tried the a more complex solution and set up an activation script. This is when the problems started.