Does SQL trigger fire before transaction commit

Shahzad786
 
on Jun 08, 2021 10:57 PM
357 Views

Hi Everyone,

I am using trigger on insert or update and also using transaction handling from vb.net

Can u please tell me trigger fire before my transaction commit or after commit?

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Jun 08, 2021 11:02 PM

Hi Shahzad786,

A trigger always executes in the context of a transaction (every DML statement operates within a transaction).

Refer below link for more details.

https://stackoverflow.com/questions/3131003/tsql-create-trigger-with-transaction-and-try-catch-block