حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Does SQL trigger fire before transaction commit

Shahzad786

Shahzad7...

SOLVED CLOSED ACTIVE ANSWERED
User: Shahzad786
Posted: on Jun 08, 2021 10:57 PM
Forum: SQL Server
Replies: 1
Views: 1705

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?

dharmendr

dharmend...

0 1

Reply
User: dharmendr
Replied: on Jun 08, 2021 11:02 PM
Report

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2026 ASPSnippets.com ALL RIGHTS RESERVED.