Post reply

Could not find store procedure ''sp_Msupd_benefit''

  • March 3, 2006 at 4:54 am

    #90620

    Hi,

    I am setting up transactional replication between two server 'server A' and 'server B'. 'server A' is a publisher and server B is a subscriber both datbases have same schema and data. when I change any data at subscriber, replication gives me the error that "Could not find stored procedure 'sp_MSupd_

    '.

    (Source: AZAMPC (Data source); Error number: 2812)" .

  • March 3, 2006 at 11:13 am

    #624686

    "when I change any data at subscriber".  Did you mean publisher? 

    Your subscriber is missing the update proc for

    . 

     

  • March 3, 2006 at 11:20 am

    #624689

    I have resolved the issue by executing stored procedure "sp_scriptpublicationcustomprocs " on publishere then i save the result in a .csv file then i execute this file on subscriber then it works actually i used transaction replication with nonsync option

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

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