You might want to look at [1]; you can send a message to a queue and process that independently. It breaks transactional boundaries though (if you abort the tra

You might want to look at [1]; you can send a message to a queue and process that independently. It breaks transactional boundaries though (if you abort the transaction the message is still in the queue). Using transactional queues will probably not help because then the transaction has to wait for the message to be processed so you're back to square one. [1] http://www.madeiradata.com/service-broker-asynchronous-triggers/ http://www.madeiradata.com/service-broker-asynchronous-trigg...