DBA > Job Interview Questions > Replication - MS SQL Server 7.0 Enterprise Manager

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