• Hi,

    Instead of just deleting the records on the publisher, insert them in an archive table on the subscriber then do your publisher cleanup.

    Create a view on the subscriber with both the replicated table and the archive table.

    Alter your reports to use the view instead of the table.

    This will also mean that if you have to create a new replication snapshot, you won't lose all your archival data on the subscriber.

    Would this work for you?



    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort