August 19, 2011 at 7:28 am
Hi all,
I'm trying to add an article to a publication, using the following code:
exec sp_addarticle
@publication = N'My_Publication',
@article = N'mytable',
@source_owner = N'dbo',
@source_object = N'mytable'
After running the code I can see that the article has successfully been added to the publication.
However if I insert any data into this table or add a column, the changes are not made on the subscriber. In replication monitor it will say '1 transation with 1 command were delivered'.
However I will not see any change on the subscriber side.
If I instead add the article using Management Studio then it works fine.
Am I missing anything?
By the way I added the table manually on the subscriber side.
August 19, 2011 at 7:50 am
Did you start the snapshot agent after running the query?
-Roy
August 21, 2011 at 9:40 pm
I think that you will also need to add a subscriber to the article (using sp_addsubscription)
August 22, 2011 at 12:15 am
happycat59 (8/21/2011)
I think that you will also need to add a subscriber to the article (using sp_addsubscription)
and generate the single table snapshot.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply