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

  • 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.

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

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

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