Take the 2-minute tour ×  At work we have just started building
an auditing framework for our database (i.e. to log what data
has changed when it is created or updated).  We'd quite like to
implement this using triggers as data sometimes gets imported
into the system from other places, not just via the front-end.
This seems to be a fairly common solution.  However I'd like to
make one addition: if a user runs an update which updates more
than one table, I'd like those to be grouped together in a batch
(i.e. to generate a unique batch ID for each set of updates).
The problem is, getting a batch ID from within a trigger. Each
update will run within a transaction, so I was wondering whether
I could use the Transaction ID to generate a batch ID. However I
can't find a way of accessing the Transaction ID anywhere within
T-SQL.  Anyone have any ideas?  P.S. - We are running SQL Server
2008, if it makes any difference  share|improve this question
add comment  3 Answers  up vote 3 down vote accepted  you can
just us