Post reply

stored procedure dropped on subscriber side

  • January 26, 2006 at 8:04 am

    #96458

    I have transactional replication environmnet where stored procedures are used on subscriber servers for insert, update, and delete. For some reason, the stored procedures on sbuscriber servers were dropped. Does anyone know why? Thanks for your help!

  • January 28, 2006 at 9:08 pm

    #617638

    Stored procedures used by replication are not dropped by replication. When applying a new snapshot they are dropped but recreated again, so maybe they where manually dropped.

    You can recreate them by applying the snapshot again by reinitializing the publication or you can also run sp_scriptpublicationcustomprocs at the publisher to generate the scripts needed to create all the replication stored procedures at the subscriber.

    Hope it helps!

     

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

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