Post reply

Tran Replication failing at Distribution agent - cannot find psorc sp_MSUpd..

  • August 12, 2005 at 5:16 am

    #87097

    HI there, hoping soemone can help.. Since I changed the service account my replication distribition agent stopped working, with the error:

    Could not find stored procedure 'sp_MSupd_[tablename]'.

    Yet the sproc does exist on the remote server and I checked the service account has exec permissions on it too.  Any ideas?

    Many thanks,

    Rob.

  • August 12, 2005 at 5:51 am

    #581715

    answered my only problem  - the object owner was the previous service account, changed the db_changeowner.

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

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