Hi!

Thanks for this worthy article.

I have a question about it: the author states that TRUNCATE TABLE "invalidates the transaction log".  I'm certainly missing the point here; indeed, TRUNCATE TABLE is a fully logged operation that can, for instance, be rollbacked.

The three troubles underlined, in the BOL, with TRUNCATE TABLE are:

• It resets IDENTITY columns to the seed.
• It cannot be used on a table referenced by a FOREIGN KEY.
• It cannot activate a trigger.

Kalpesh, maybe you meant one of these three?

Thanks!

Xavier