>You need to truncate tables in the correct order. How log would it take to create a sp that would truncate all your tables?
>
See my answer. If you disable all constraints, the order to truncate will not matter.
If it's not broken, fix it until it is.
My Blog