0

I have a challenge with replication on SQL Server 2000. The replication has full permissions, but still I get this below error. The SQL Server 2000 is installed on the C: Drive, but the database is on E:.

\myserver\Replication\unc\myserver_GS_ECC25_2675_Publication1\20130813090100\SpInsertSbraConf_1469.sch' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001)

Insert Error: Column name or number of supplied values does not match table definition. (Source: myserver (Data source); Error number: 213)

Improve this question

1 Answer 1

Reset to default
1

That error would imply to me that there is a table layout difference between the publisher and the subscriber. Have any recent updates to the DB structure been applied to one but not the other?

You could run a DB comparison tool (something like the free edition of http://www.sqleffects.com/Articles/Product/sqlAccordInfo/aboutSqlAccordCommunityEd.html should be more than sufficient) against the two databases to check for this.

You probably shouldn't be using SQL 2000 any more - it is somewhat old and the extended support period for its last release (SP4) ended in April this year.

Improve this answer
10
  • Thanks David. The subscriber is an empty databse, so I am trying to send the snapshot of the publisher to the subscriber first, so I am not sure what table the application is talking about. Yes, it is only sql 2000 that works with that software, and the manufacturer has no alternative to produce diffrent databse for the software.
    – oshaye3
    Sep 6, 2013 at 10:04
  • I would not pay for software that only works on something that old. It would not fill me with confidence in the rest of the product!
    – David Spillett
    Sep 6, 2013 at 10:30
  • yes, you are right. But is from aircraft manifacturer and could not work with other database, so they stick to this sql 2000. I hope I can sort this out, but I will keep in up to date wht you may help me to do. The tables in each database is almost 200 and the store procedures are almost 2000, so i really just do not know which table to start working on. I will look at the link to the aforementioned software you sent. Thanks for your time.
    – oshaye3
    Sep 6, 2013 at 10:40
  • If you run the suggested tool or one like it, it will compare all the objects in each database and tell you if any differ (or are missing in one of the two places).
    – David Spillett
    Sep 6, 2013 at 11:08
  • Yes, I will try the tool expecting them to send it it my email which is the community edition Cheers.
    – oshaye3
    Sep 6, 2013 at 11:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.