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)
Friday, February 24, 2012
Distribution agent cannot find sp_MSupd_users
Labels:
agent,
cound,
created,
database,
detectedtransactions,
distribution,
error,
failed,
logreader,
microsoft,
mysql,
oracle,
publication,
replication,
server,
sp_msupd_users,
sql,
status,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment