I have snapshot replication from A to B.
Everything ran fine, until someone (the software vendor) in A dropped and recreated (identically) some tables being replicated.
Replication gave no errors, the articles are still checked in the Publication properties window, but those tables are not replicated since than.
Since this situation will occur again, how could I manage it?
"B" Database is used only for reading, no data editing, hence I'd be considering a quick&dirty Drop table + INSERT INTO via LinkedServer, even because only 100 tables are involved with small amount of data.
Thanks in advance