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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2010-07-26 : 14:26:02
|
| 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! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-07-26 : 15:02:04
|
| You followed the proper procedure. Verify that your snapshot by looking at the replication folder on the disk as well as via replication monitor.The replication stored procedures should have been created on the subscriber though and not on the publisher. Not sure what would have caused them to be created on the publisher except perhaps replication not being configured properly. Are you sure that replication is working for the other articles?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2010-07-26 : 15:28:53
|
| Tara - I got a bit confused with your 2nd statement. Verify what about the snapshot? I did verify that it ran in the Replication Monitor, as I ran it there directly (by right clicking on the agent and choosing 'start agent'). The 'action time' is shown as of time i ran it.Replication is definitely working for other articles, and has been working for past 5 years. The stored procedures at the publisher seem to be read only and have _1 attached to their name [e.g. sp_MSsync_del_Article_1], while at the subscriber they are not read only and no _1 at the end.Is there anything else I can try?Thank you! |
|
|
|
|
|
|
How to add new article to existing publisher?