>Hi Eric,
>
>Thanks for the info. I can't use Truncate table on a table referenced by a foreign key constraint.
>
>I'll have to figure out a way to delete the constraints - before truncating the tables - and then rebuild them once all appropriate tables have been truncated.

Can you temporarily drop with contraint with

ALTER TABLE Tablename NOCHECK CONSTRAINT ConstraintName

then reestablish with

ALTER TABLE Tablename CHECK CONSTRAINT ConstraintName