I am new to SQL2008 R2. I successfully set up a transactional replication. Also, when I change a definition of an existing table it is replicated to my subsciber.
But when I create a new table it is not replicated. Is there a way to set up a replication that automatically replicates the new table to a subscriber?
Or, if not - what is the best way to manually replicate the new table in the subscriber and then expand the replication so that the data of this table is replicated as well?
(Do I have to create a completely new replication for this?)
View Complete Post