Hi,We have transactional replication set up on our MSSQL 2000 servers. I am trying to add a new article to the publisher, but it does not seem to work correctly.Using the GUI interface, I added a new article. I then ran the Snapshot agent, which seems to have not done anything.I checked the publisher and see that i have 3 replication stored procedures created there. However, I do not have them in the subscriber.I do not want to reinitialize everything.What can I do in this case to simply add an article to an existing publisher?Thank you!
You may use sp_addarticle to add article to an existing publication followed by sp_refreshsubscription, IMO this will then do not reinitialize whole snapshot.
ghemant,Will any of these 2 steps create the necessary (insert/delete/update) stored procedures on the subscribers?Thank you!
In order for replication to work 3 stored procedures need to be created on the subscribers (sp_MSins_ ... sp_MSdel ... sp_MSupd). When everything is initialized from the begining, these 3 are created.My question was - if I use the steps you described, will these 3 stored procedures be created on all the subscribers specifically for the table I will be adding as an article?THank you!
Is this really for SQL 2000 version or higher version? I believe there are certain design restrictions in SQL2K version to enable the option for you.