I have a database that is using transactional replication with immediate updates. The publisher and subscriber have been replicating perfectly for about 2 years.
Just the other day I created two new tables. I then went to the publication and added the new articles. After this I turned on the snapshot agent. The agent created the tables on the subscriber and put in all the data.
I just noticed that any changes that I make on the publisher replicate down to the subscriber, but if I make a change at the subscriber, nothing happens. Does anybody know why this is?