Error with replication

Question

Hi All,

receiving the following error on replication- please assist.

Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x00259DD30004FC70000400000000, Command ID: 1)

Error messages:
Could not find stored procedure 'sp_MSdel_dboSchedule_msrepl_ccs'. (Source: MSSQLServer, Error number: 2812)

Answer 1

HI @Darren Naidoo ,

The stored procedure for replication are not present in the subscriber databsae, please check and ensure stored procedure('sp_MSdel_dboSchedule_msrepl_ccs') is available.

For missing stored procedure, you should run against the publication to generate a script, just use sp_scriptpublicationcustomprocs to regenerate the missing proc and execute the output against the subscriber

Resolve SQL Server Replication Error - Could not find stored procedure
Could not find stored procedure sp_MSins_dbot_tableName

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.