• Replication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.

    Also, do you need to capture UPDATE activity or just INSERTs?

    Finally, are you on Enterprise or Standard Edition?

    CDC could work well for this if you are on Ent Ed (unfortunately, CDC is not available on Std Ed).

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