Post reply

sp_msupd error

  • July 18, 2002 at 1:28 am

    #78991

    Hi Guys,

    I am trying to create a snapshot replication. I am including around 16 tables for replication. It gives error like "Could not find storedprocedure 'sp_MSupd_users'"

    here users is the table which I used in replication.

    What will cause this error ?

    Thanks

    Jerish

    dess@satyam.net.in

  • July 18, 2002 at 9:59 am

    #433018

    SQL creates a set of procs for each replicated table on the subscriber. You seem to be missing the update one. You can replace it manually, just follow the syntax from one of the others, generate a new snapshot, or there is a proc that will regen the procs for you, cant remember the name though!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

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

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