Hey I've been playing around this morning, with some example SP and example triggers, trying to write an error handler and testing how to structure the try\catch blocks etc.

So I've got one stored proc which opens a transaction then does an update (which fires a trigger). The weird thing is the @@TRANCOUNT when printed from within the Trigger is 1? Not 2? I don't understand, shouldn't it be 2, 1 for the opened transaction within the SP and 1 for the implicit trigger transaction?.

Also when doing the same update outside of the stored procedure (with no transaction), the same the printed out Trancount is still 1!!