Tom.Thomson (10/5/2010)
Nice question.But is there something wrong with the documentation? The BoL page referenced states
@@TRANCOUNT is incremented by one when entering a trigger, even when in autocommit mode. (The system treats a trigger as an implied nested transaction.)
which suggests that the two rows logged for the insert of value 2 (which occurred in an explicit transaction) should have tc = 2 not tc = 1.
I don't know. You are right but experiments show this behaviour.
Many times I read BOL or some other documentation I feel like being in the helicopter.