Is there a way to get trigger id in sql server?

Question

I am using trigger after update , I created table to store the changes, I want record also the reason behind change , so when ever the trigger fires I want to update that specific record , is there a way to get that 'transaction ID' to be used when updating. like .. Update tblAudit set reason = 'some reason' where ??

possible duplicate https://stackoverflow.com/questions/1265386 — devio, Mar 07 '20 at 08:37

score 0 · Accepted Answer · answered Mar 07 '20 at 08:09

0

Work on SQL Server 2016 or later

Use SELECT CURRENT_TRANSACTION_ID()

answered Mar 07 '20 at 08:09

Nayanish Damania

542
5
13

Is there a way to get trigger id in sql server?

1 Answers1