SQL Server Performance

How to Avoid deletes in Subscriber...!!!

Discussion in 'SQL Server 2005 Replication' started by krajdba, Mar 5, 2007.

  1. krajdba New Member

    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
  2. dineshasanka Moderator

    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/
  3. madhuottapalam New Member

    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
  4. dineshasanka Moderator

    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/
  5. MohammedU New Member

    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
  6. dineshasanka Moderator

    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/
  7. krajdba New Member

    Thanks. Problem fixed.


    raj
  8. dineshasanka Moderator

    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/
  9. MohammedU New Member

    KRajDBA,
    If you problem is fixed...Can you plese share your solution...

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  10. krajdba New Member

    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
  11. MohammedU New Member

    Thanks for your feed back...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page