SQL Server Performance

Stopping Delete at Subscriber

Discussion in 'SQL Server 2005 Replication' started by Fais, May 5, 2009.

  1. Fais New Member

    Hi all,

    1) If I dont want 'Delete' statements to propagate to subcriber.........What needs to be done, when creating new publication (or) modifying existing publication. and if I modify any stored procedure. what need to be modified.

    2) If above is done, will this have any adverse effect on update statements going to subscbier as I think update is : Delete + Inserts.

    Please share your thoughts.

    /* This is SQL Server 2005 Transactional Replication */

    Thanks.
    Fais, May 5, 2009
    #2

  2. pdevadiga New Member

    Hi,In the article properties...under Statement Delivery...Edit the following "DELETE delivery format" to --> Do notreplicate DELETE statements....and you are good to go.Regards,Prashant
    pdevadiga, May 6, 2009
    #3

Share This Page