asynchronus triggers

Question

Greetings

I need to know what is the meaning of asynchronoous trigger and is there difference between asynchronus triggers and the normal triggers that is used in sql-server after or before inserting ,updating,deleting

thnx

Answer 1

I think your getting confused with Service Brokers.

Triggers always execute synchronously, in the context of a given transaction. If you need to invoke an asynchronous process from within a trigger, use a Service Broker.

It's basically like a Queue - you send things to the queue, then can go on about your business without waiting for it to finish.

However, there is a lot more to it than that, have a read of the link.