Community

What happens in a trigger stays in the transaction: T-SQL Tuesday #106

(Kenneth Fisher) Anything that happens in a trigger happens within the same transaction of the command that called it.