Subject Need help on getting transaction id
Author vlaivmail
Hi all,

I need some help on getting transaction ID in body of trigger.

(it does not have to be actual ID but kind of unique ID for every
transaction (like generator value) datatype Int32).

I tried all sort of tricks with temporary tables and transaction
but nothing works ...

I am making a user/table activity logging system and need to record
transaction ID (so I can determine
group of operations that was done in same transaction).

Thanks in advance,

Vladimir Vlaisavljevic