The presence of a dependent foreign key will prevent truncation of the table. I think I'll use that to my advantage.

-----------------------------------------------------------------------------

PRINT 'Creating Tables'

CREATE TABLE TestTruncate(I INT IDENTITY(1,1), x CHAR(1),...

I'm looking for a structural solution to prohibit truncation. I just tried this method of preventing TRUNCATE TABLE and it did not appear to work (SQL Server 2005). ...