BOL - Restrictions
You cannot use TRUNCATE TABLE on tables that:
•Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.)
Do we have any chance to use a table that has a foreign key that references itself?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius