Replication problem

• sql_fan

  SSC-Addicted

  Points: 462

  More actions

  February 15, 2006 at 1:35 pm

  #152766

  I have a transactional replication between 2 servers and I am replicating two tables from server a to server b.But My replication is failing from last few days and I am getting this error when the job Runs.

  Cannot drop the procedure 'sp_MSins_event', because it does not exist in the system catalog.  The step failed.

  AND also when I look the the agents

  IN the distribution agents

  Under publication it is showing <multiple Publications> and under last actions its showing the above message.

  But I have only one publication in the replication.

  When I tried to reinitialize the subscription the data in one of the table on the subscribing server is getting deleted.

  How can I fix this problem.

  Thanks.

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  February 15, 2006 at 3:40 pm

  #621219

  This thread should be in the Replication Forum!

  However, at what stage does the replication fail? Does it fail on the initial snapshot or when transactions are getting replicated?

  Also, is your publication configured to replicate Stored Procedures?

  ---

  Kindest Regards,