Replication followed a delete at the publisher.

• Leonardo Bazan do Carmo

  SSC Journeyman

  Points: 95

  More actions

  July 19, 2007 at 2:45 pm

  #93540

  Hello,

  I´ll need to create a plan for the following scenario:

  Server A (Publisher) - Server B (Subscriber) in a transactional replication.

  -When perform a insert into publisher, SQL Server must replicate the statement. After, I want that SQL Server deletes the rows affected on the insert on the Server A (Publisher) and don´t replicate to the Server B.

  I want that a transaction has been replicated to server B and deleted from the server A. It´s possible?

  Thanks a lot!

  Leonardo

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 20, 2007 at 2:11 pm

  #721274

  Just comment out the delete stored procedure code on the subscriber!

  
  * Noel