By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
In this video, i have shown a demo on how to handle error, if subscriber deletes a record without knowing to publisher.
Part 1: • Replication in SQL server - Part 1 ||...
Part 2 : • Replication in SQL server - Part 2 ||...
Part 3 : • Replication in SQL server - Part 3 ||...