We have transactional replication model. Now the thing is that 20 or 30 tables of publisher’s have changed. So to make it replicated, I am having two options;-
(1) drop these articles from replication and create a new publication
(2) rebuild the publication entirely
What’s ur suggession? Should I go for option 1 or option 2?