Post reply

Replication problem

  • 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.

  • 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,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply