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
visibility
but nothing works ...

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

Thanks in advance,

Vladimir Vlaisavljevic