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
[quoted text, click to view] "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...
> > 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
>
>
