Groups | Blog | Home
all groups > sql server (microsoft) > june 2005 >

sql server (microsoft) : Stop replication of deletes



stephen atkins
6/2/2005 8:18:49 PM
Hello all. We are just getting started with replication and I'm
wondering if there is a way to not have deletes replicated. I know I
could manually remove the delete trigger from every table but I'm
intrested in have this a bit more automatic (like when its creating the
subscription).

Thanks

Simon Hayes
6/3/2005 12:59:00 AM
If you don't replicate deletes, then you're not really replicating the
data any more - what happens if a row on the publisher is deleted, then
a new row is inserted with the same primary key? If you don't replicate
deletes, then the replicated insert will fail on the subscriber due to
a primary key violation.

Having said that, it's not clear why you want to want to do this -
perhaps if you can give some more details of what you need to achieve
someone will have a suggestion.

Simon
AddThis Social Bookmark Button