SQL Server 2000 Replication 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)
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.