Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-08-19 : 09:26:51
|
| 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? |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-08-19 : 11:24:35
|
| I fixed it by running sp_refreshsubscription. |
 |
|
|
|
|
|
sp_addarticle not working properly