No, you can never rollback a transaction with a TRUNCATE TABLE statement, regardless of recovery mode

Explanation

---

there is no documentation on a non-existant concern

Transact-SQL Statements Allowed in Transactions

You can use all Transact-SQL statements in an explicit transaction, except for the following statements:

ALTER DATABASE
ALTER FULLTEXT CATALOG
ALTER FULLTEXT INDEX
BACKUP
CREATE DATABASE
CREATE FULLTEXT CATALOG 
CREATE FULLTEXT INDEX 
DROP DATABASE 
DROP FULLTEXT CATALOG
DROP FULLTEXT INDEX
RECONFIGURE 
RESTORE

...
UPDATE STATISTICS can be used inside an explicit transaction. However, UPDATE STATISTICS commits independently of the enclosing transaction and cannot be rolled back.

Henrico Bekker (2/5/2012)

---

Thanks for the question, but please explain why:



isn't also correct?

Koen Verbeeck (2/5/2012)

---

Because you can rollback a transaction with a TRUNCATE TABLE statement?

Henrico Bekker (2/6/2012)

---

Tsk, thanks Koen....
Slow Monday morning for me....ignore me for the day ...