Problem in Transaction replication

  • Hi,

    How can I delete any sql command like delete commands from distributor so that it would not be replicated to the subscriber.

  • If your looking to delete a particular command, you'll find all replicated commands in the REPLCmnds table in the distributor, and can track down the one you need by publication and article, but I wouldn't recommend this, unless it was an emergency situation.

    If your looking to prevent deletes from replicating to the subscribers, in general, then you need to set up your replication to not replicate these to start with, by doing the replication by proc, and stubbing our the delete proc.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply