I have recently setup a Merge Publication with two other servers subscribing
to it. While I was checking the progress of the sync I have noticed that
Expired Subscription Agent is failing. The error it is giving is:
Invalid object name 'sysarticleupdates'. [SQLSTATE 42S02] (Error 208).
Has anyone got any suggestions?
This is probably symptomatic of much larger problems.
I would find a SQL Server with the same version and sp, locate
sysarticleupdates, right click on it in EM, select copy and then paste it
into your subscription database on your subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:7B52FB71-6159-4818-85EC-7216AB277473@.microsoft.com...
> I have recently setup a Merge Publication with two other servers
subscribing
> to it. While I was checking the progress of the sync I have noticed that
> Expired Subscription Agent is failing. The error it is giving is:
> Invalid object name 'sysarticleupdates'. [SQLSTATE 42S02] (Error 208).
> Has anyone got any suggestions?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment