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.