Thats an interesting question, as far as i was aware transaction where managed at the session id, db and object id level.

All this information should be in syslocks, or you could return the session id from @@Spid.

Would interested to know if there is a unique transaction id or guid that is visible and not just internal to SQL.