Replication ERROR 208: invalid object name 'syspublications'

Hello,
Server A and B are both running on NT4.0 SP6.
Server A and B both have SQL Server 2000 SP2 installed.
Server A is the Publisher and Distributor.
Server B is the subscriber.
At one time B was able to see and subscribe to Publication on Server A.
I manually deleted all traces of replications from syspublications,
sysarticles, syssubscriptions, basically from all of the replication tables
in the user database.
I then recreated the publication on Server A.
I then open Enterprise Manager on Server B, Right clicked on Subscriptions
and selected "New Pull Scriptions...". The wizard appears and list Server A
and when I try to expand the server to list the Publication an error message
appears stating:
"ERROR 208: Invalid object name 'syspublications'. Invalid object name
'sysextendedarticlesview'."
Any idea what might be causing this problem?
Thank you.
Scott
Are these objects on the subscriber? If not, locate them on a different
subscriber/publisher, right click on them in EM and select copy. Then go
back to your subscriber and paste them into query analyzer and execute the
script.
Then try again.
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
"Scott Yu" <ScottYu@.discussions.microsoft.com> wrote in message
news:344E037E-9CB8-4D5E-BF53-CE16EBB564E2@.microsoft.com...
> Hello,
> Server A and B are both running on NT4.0 SP6.
> Server A and B both have SQL Server 2000 SP2 installed.
> Server A is the Publisher and Distributor.
> Server B is the subscriber.
> At one time B was able to see and subscribe to Publication on Server A.
> I manually deleted all traces of replications from syspublications,
> sysarticles, syssubscriptions, basically from all of the replication
> tables
> in the user database.
> I then recreated the publication on Server A.
> I then open Enterprise Manager on Server B, Right clicked on Subscriptions
> and selected "New Pull Scriptions...". The wizard appears and list Server
> A
> and when I try to expand the server to list the Publication an error
> message
> appears stating:
> "ERROR 208: Invalid object name 'syspublications'. Invalid object name
> 'sysextendedarticlesview'."
> Any idea what might be causing this problem?
> Thank you.
> Scott
|||Hello Hilary,
Are these objects on the subscriber?
######################################
Every article in the publication reside on Server A, which act as the
Publisher and Distributor. All articles that are part of the replication job
are dropped from Server B before Server B take part in the replication. From
Server B, I would like to create a Pull subscription and set the option to
create the schema from the snapshot on Server A, but every time I do this I
get an error message. The message states "SQL Server Enterprise Manager
Could Not Retrieve Information About The Publication From the Publisher.
ERROR 208: Invalid object name 'syspublications'. Invalid object name."
I was able to ping Server A from Server B and all of the linked services
between Server A and B are working fine in both direction.
I am currently able to Push the subscription down to Server B from Server A,
but would like to have Server B Pull the subscription instead.
Hope this answers your question. Thank you so much for your help.
Scott
"Hilary Cotter" wrote:

> Are these objects on the subscriber? If not, locate them on a different
> subscriber/publisher, right click on them in EM and select copy. Then go
> back to your subscriber and paste them into query analyzer and execute the
> script.
> Then try again.
> --
> 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
> "Scott Yu" <ScottYu@.discussions.microsoft.com> wrote in message
> news:344E037E-9CB8-4D5E-BF53-CE16EBB564E2@.microsoft.com...
>
>
sql