We recently set up replication on SQL Server 2005 and it's working fine till yesterday. We added a new column to the published article yesterday and that broke replication and threw an error "procedure or function sp_MsIns_TableName is missing parameter @c76 (the newly added column is 76th column in this table) Error Number 201" but I verified the replicated system stored procedures (sp_MSins_%, sp_MSupd_%, sp_MSdel%) are up to date with latest schema changes and even the subscriber table has the new column. I have no idea why it's throwing the above error messase ("procedure or function sp_MsIns_TableName is missing parameter @c76 (the newly added column is 76th column in this table) Error Number 201" ).
After lot of struggle to crack down the error, I thought the new column would be the problem and dropped the column on publisher and updated all replicated stored procedures and subscriber article (dropped new column) but now I got different error and that one says "Procedure or function sp_MSins_HHResume has too many arguments specified. (Source: MSSQLServer, Error number: 8144)".
After some online research, I found that the publisher and subscriber are on two different versions builds in my environment (Publisher is on SQL Server 2005 SP2 and Subscriber is on SQL Server 2005 SP1) and still I am not sure about this one. I really appreciate if you can share your experience about this issue or point me to the right source of information.