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 |
|
dshelton
Yak Posting Veteran
73 Posts |
 Posted - 2003-03-04 : 02:28:06
|
| I have a transactional replication setup between two servers, it has been running smoothly for a few months now. But I went to add a couple of columns to an article and it continuosly fails now. This is the error message:Too many arguments were supplied for procedure sp_MSupd_repl_doctor_bI have investigated this error and since removed the fields but I still get this error. I have even removed the reference to this procedure in the article properties but I still get the same problem.... any ideas?? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-04 : 05:11:30
|
| Deselect that specific article replication. After making changes on the publishing table. re-select the article replication with option drop and recreate the table at the subscriber. I belive this will work.Regards,Sekar |
 |
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2003-03-04 : 18:53:00
|
| For some reason I cannot deselect the article. Could the reason be that I am replicating to a SQL 7 database? |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-06 : 06:43:27
|
| No. I don't think so. The article can be deselected only when the subscriber is not active. Remove the Subscriber and try again, hope this will solve the problem.Regards,SekarSuccess is not a destination that you ever reach.Success is the quality of your journey. |
|
|
|
|
|
|
ERROR adding column to article