Running - SQL 2K Win2K
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
Hilary Cotter
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:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
No comments:
Post a Comment