My supervisor is hesitant to use a trigger in a process because if there is a network interruption at just the right time, the process would not complete. Does SQL Server include the trigger in the calling procedure's transaction? If not, what is the best way to implement this?
Ensuring SQL Server Trigger Execution
sql servertrigger
Related Question
- Why TRY CATCH Does Not Suppress Exception in SQL Server Trigger
- Sql-server – how to use trigger to make SQL Job’s step success or fail
- Sql-server – SQL Server Transactional Replication With subscriber trigger returning a value
- SQL Server 2012 – Trigger/Event When Transaction Finishes
- PostgreSQL Trigger – Detect Update or Insert Origin
- Is it possible to make a trigger that does not allow INSERT
Best Answer
Yes. Triggers occur as an implicit nested transaction within the scope of the caller's transaction. The trigger will commit or roll back as part of this transaction.
See: