I am having an issue, I have a publication with 2 subscriber databases. The second subscriber database is a recent addition. Previously I only had one subscriber database and when I added a new article, I would simply add the new article to the publication then run a snapshot. The new table would appear in the subscriber database and would the be replicated to going forward. Now that there are two subscriber databases, the table does not appear in either of the subscriber database. After I add the article to the publication and run the snapshot.
--This statement shows the table as being replicated.
SELECT *
FROM sys.tables
WHERE is_replicated = 1
Thanks in advance,
DK