SQL Server Performance Forum – Threads Archive

Exclude delete statements in replication

Hi, Can I exclude delete in SQL replication?
Please tell me how….
Regards, Riya

---

I believe you can not exclude delete statements in SQL transactional/Merge replication..
[not aplicable in snapshot replication] But if your application grants..can deny delete statement on tables itself. Deepak Kumar –An eye for an eye and everyone shall be blind

---

There is a couple of ways to exclude the delete commands to be replicated to the subscribers. You can specify what action should be taken for the delete/insert/update command, specify NONE and no action will be taken. You can also specify that a custom stored procedure should be used for the delete command. More info:
sp_addarticle:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_27s5.asp sp_changearticle:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_4yjp.asp custom procedures:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4hwz.asp / Mike

---

]]>