How to Avoid deletes in Subscriber…!!! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to Avoid deletes in Subscriber…!!!

Hi Gurus, I have setup a publisber and subscriber between core database and a report db in two different servers. In the Subscriber database I would like to AVOID DELETE’s and wanted only UPDATES and INSERTS. How can I achive this. Please help. Very Very Urgent. Thanks & Regards raj
You can revoke delete permission of users of the subscriber database —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

i don’t think it is possible… what i could understand is …. Raj need a partial/customized Transactional replication in which the delete commands are not replicated … only insert/update are replicated… in that case i dont think it is possible…
Madhu
I had the same problem and I introduced the workround. I stopped the users from deleting data rather than stop propergating deleted data. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

I believe it doable in article Properties, Commands Tab…
you can replace the procedure name in "Replace DELETE commands with this stored procedure call" with custom procedue to do nothing or you can simply try typing NONE. MohammedU.
Moderator
SQL-Server-Performance.com
yes you can do this if you have transactional replication. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Thanks. Problem fixed.
raj
well, how did you fix this. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

KRajDBA,
If you problem is fixed…Can you plese share your solution… MohammedU.
Moderator
SQL-Server-Performance.com
Hi Guys, All I did is typed "NONE" in "replace the procedure name in "Replace DELETE commands with this stored procedure call" with custom procedure" in the Article properties. raj
Thanks for your feed back… MohammedU.
Moderator
SQL-Server-Performance.com
]]>