• I agree, definitely save, truncate and (re)load.

    Btw, you should very likely change the clustered index on the table to insert datetime if it's currently based on an identity column. If you prefer, you can add the identity column after the datetime to guarantee a unique key.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.