Replication agents are failing with the followin

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Replication agents are failing with the following error. What's wrong?

Too many arguments were supplied for procedure <A_System_Stored_Procedure_Name> (for example: sp_MSenumschemachange)
The most probable reason for this error could be, mismatched service pack versions between the SQL Servers participating in replication.
Make sure all the participating SQL Servers are running with the same service pack installed.

(Continued on next question...)

Other Job Interview Questions

• Replication monitor is showing errors (White X mark on a Red circle), though there are no errors on any agents. How to get rid of these X marks?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• Merge agent is failing with the error: 'The process could not initialize "database reconciler". Check to see if the component is registered correctly’. Where to look?
• Unable to specify a remote distributor for a Desktop/MSDE publisher. Why?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• A non-dbo owned table when merge replicated to the subscriber, is being owned by dbo. Is there a way to maintain table ownership in merge replication?
• Setup Transactional replication with "Immediate Updating Subscribers". Changes on publisher get replicated to the subscriber ...
• Replication agents are not starting and are failing with the error: 'Replication agent is not registered properly. Rerun SQL Server setup'. What's wrong?
• A non-dbo owned table when merge replicated to the subscriber, is being owned by dbo. Is there a way to maintain table ownership in merge replication?
• How to let merge replication use your own rowguid column?
• More...