Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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)

share|improve this question

1 Answer 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.

share|improve this answer
    
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 '13 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 '13 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 '13 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 '13 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 '13 at 11:12

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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