Iulian -207023 (10/21/2010)
With all these restrictions what kind of application would use truncate table?[/b]
One that supports RDMS management and Administration.
It can take up to 3 hours to transactionaly Delete and re-insert 3 million rows during a table schema update. That time is reduced to about 30 minutes if you clear the table using Truncate table.
Most people that have to work with deploying production DB changes understand this, or learn about it quick.
redgate has several utilities for RDMS management that understand this also.