>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
Chris McCandless
Red Sky Software