Sean Lange (8/22/2016)
Great back to basics question. We have seen this topic on QOTD many times. Still quite shocking that at the time of my comment there are 33% of the answers thinking that TRUNCATE will not be rolled back.
I agree that's shocking, but I'm even more shocked that 8% of answers believe that DELETE will not be rolled back.
Of course it's interesting that no DML trigger for TRUNCATE TABLE is supported because, although it's a DML statement, truncation is not in any DML Event Group because it isn't a DML Event. Seems a bit strange to me that the effect of a DML statement can somehow not be a DML event.