Posted by hallpa1@yahoo.com on 03/17/06 19:45

Most of the tables do not have a clustered index, one does.

I thought about the temp table option, but the database may get rows
updated while purging the old rows. I would then lose those updates
when I trunc the parent table.

[Back to original message]