I have a table-article being replicated as part of a publication that replicates DDL commands. Historically, executing ALTER statements on replicated tables has not caused any problems.
However, I recently executed the following ALTER:
ALTER TABLE my_table ADD my_column INT NULL DEFAULT(0)
I immediately started receiving the following error on one subscriber:
Procedure or function 'sp_MSupd_mytable' expects parameter '@pkc1', which was not supplied.
And this error on another subscriber:
rocedure or function 'sp_MSins_mytable' expects parameter '@c7', which was not supplied.
I was under the impression the sp_MS-stored procs would update automatically to reflect schema changes and that there shouldn't be any problem if the Log Reader is processing changes as it should. Anything jump out as the specific cause of this problem? Let me know if I can provide any other information that would help.