Expired Subscription Clean Up - REPOST

Running SQL 2k / Win 2k
I am getting an error on Replication Monitor->Agents->Misc
Agents->Expired Subscription Clean up that reads 'Executed as user:
ROUSES.COM\Administrator. Invalid object name 'sysarticles'. [SQLSTATE
42S02] (Error 208) Invalid object name 'sysarticleupdates'. [SQLSTATE
42S02] (Error 208) Associated statement is not prepared [SQLSTATE
HY007] (Error 0). The step failed.'
What dB is this table or tables missing from? How do I recreate
them?
AHIA,
Larry...
Sounds like a publication database. For some reason there seems to be an
bogus entry in distribution.dbo.mspublisher_databases or
distribution.dbo.mspublications.
Its looking at the view in sysextendedarticlesview in a publication
database. I can't tell which one it it. Run profiler and look for the db id.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1140014373.809026.60790@.g47g2000cwa.googlegro ups.com...
> Running SQL 2k / Win 2k
> I am getting an error on Replication Monitor->Agents->Misc
> Agents->Expired Subscription Clean up that reads 'Executed as user:
> ROUSES.COM\Administrator. Invalid object name 'sysarticles'. [SQLSTATE
> 42S02] (Error 208) Invalid object name 'sysarticleupdates'. [SQLSTATE
> 42S02] (Error 208) Associated statement is not prepared [SQLSTATE
> HY007] (Error 0). The step failed.'
>
> What dB is this table or tables missing from? How do I recreate
> them?
>
> AHIA,
> Larry...
>