Post reply

Replication Setup

  • May 27, 2004 at 4:26 pm

    #85803

    I am trying to setup a test transactional replication between serverA (publisher and distributor) and serverB (subscriber) on the Pub database. The setup complete successfully. However, when I insert a record in serverA, I get the following error in the Distribution Agent History and server B is NOT updated:

    ...Could not find stored procedure 'sp_MSins_authors'.

    Please let me know what is wrong... Thank You!

  • May 27, 2004 at 5:58 pm

    #508093

    That Stored Procedure 'sp_MSins_authors' should be on the Subscription Database! This and other Stored Procedures used by Replication get created during Replication Setup!

    Try removing Replication and start again!

    Kindest Regards,

  • May 28, 2004 at 7:08 am

    #508186

    Try findin the sp in the subscriber first. If it doesn't exists, then run sp_scriptpublicationcustomprocs in the publisher in the pulblished database.

    That shoud create all the sp that you need, run them all in the subscriber, or locate the missing sp and execute it in the subscriber.

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

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