Can you please help. I am trying to do a merge replication and i get the following error:

Procedure or function sp_MSaddinitialarticle has too many arguments specified.
(Source: SUB_SERVER (Data source); Error number: 8144)
---------------------------------------------------------------------------------------------------------------
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
---------------------------------------------------------------------------------------------------------------

This error is usually caused by a schema change that isn't propagated to one or more subscribers. Was the machine reporting this problem "out of circulation" during the last schema change?

-PatP

Any network issues between the servers?
What is the default query timeout value set?

And also try to reduce the MergeHistory table rows.

Pat what do you mean by schema change because i ended up creating a new table only with 2 fields and still get the same problem, can you please elaborate on schema change

I haven't actually done this myself, but I've run into a situation where it cropped up. We eventually "deep sixed" the offending server and rebuilt a fresh copy.

Let's assume that you have 20 servers participating in merge replication to support a high transaction volume web-site. You periodically take some of them offline for maintenance. When five servers are down, you make a schema change. Four of them come back online later in the day, but one has more serious problems so it stays offline for another four days while you get parts.

When that "prodigal child" comes back online, it still won't know about the schema change. In a high transaction volume situation, you almost certainly don't have five days worth of replication saved up. Bingo, Houston, we have a problem here!

-PatP

Thanks Pat, i managed to rebuild the server and is working.

Now my other question which i already posted in the forums reads:
Is there a way to replicate the table permissions from publisher to
subscriber? I noticed that when replication takes place, the permissions
that were set up on tables on the subscriber are wiped out.