November 8, 2004 at 2:48 pm
We have a system with merge replication being pushed from the publishing server to the subscribing server. There is a problem with the merge replication failing. The error on enterprise manager is "the merge process could not initialize the subscription". When the agent is double clicked the actual error message is "Too many arguments were supplied for procedure sp_MSunmarkifneeded."
Upon investigating the stored procedures, it turns out that the publishing server has a newer version of sp_MSunmarkifneeded which expects five parameters and the subscribing server has an older version which only expects two parameters. Both servers are running the same version and service pack of SQL 7.0.
Does anyone know why this is occurring?
Thanks.
11/29 Update: I've found that the servers are not at the same version of SQL 7.0. One server is at version 7.00.623 and the other is at 7.00.1063. Apparently SP2 contains the update to some replication stored procedures.
November 8, 2004 at 4:32 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply