Hi Team,
I have a requirement where i need to remove and apply transactional replication on a daily basis.
After removing and applying transaction, as the snapshot gets created each time, control tries to insert exiting records in publisher table (which are also exiting in subscriber table) to the subscriber table and thus error comes.
How can i ensure that existing records in publisher/subscriber table are updated only to the subscriber table?
Thanks,
Salil