Friday, February 24, 2012

Distribution agent cannot find sp_MSupd_users

I created a Publication and Subscription. Once LogReader detected
transactions for replication. Distribution Agent status failed with error
"Cound not find stored procedure 'sp_MSupd_users'". I cannot find any KB on
this error, any suggestion?
Indeed, "users" is my table name
|||It seems it is caused by Command replacement on article defaults, when will
we use command replacement then?
|||Are you doing a nosync initialization? If so, you'll need to use
sp_scriptpublicationcustomprocs (please see
http://www.replicationanswers.com/No...alizations.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment