This one is not so much a teaser but it will show you what you can do in case you want to insert data in a logging table after a rollback occursWithout running this try to guess what the counts of the three tables will be after the rollbackCREATE TABLE Test (id int)CREATE TABLE #Test (id int)DECLARE @Test table (id int)BEGIN TRAN   ...