Pull Subscriptions not working at all

I cannot get a pull subscription to work at all, push works, anyone have any suggestions as to why?
I currently have 1 subscription pulling from this server, but I can't add any new pull subscriptions, I receive an error message:
From EM, on Choose Publication (Using Wizard) - Click the + next to the server I want to pull from
Could not retrieve information about publications from Publisher
Error 208: Invalid object name 'sysextendedarticlesview'
I do see this view in some of the db's that are currently replicating, but I'm not sure of where it's looking for the view in this particular instance, as I have not gotten to the point of selecting a publication.
Did my Distribution db become corrupt in some way?
Any suggestions will be greatly appreciated.
You should find this view in the subscriber. You can copy it from another
database of the same version to this one. Open up the database in EM, locate
the view, right click on it and select copy. Then paste it into QA on the
subscriber.
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
"JLS" <jlshoop@.hotmail.com> wrote in message
news:O8h6N1wCGHA.344@.TK2MSFTNGP11.phx.gbl...
I cannot get a pull subscription to work at all, push works, anyone have any
suggestions as to why?
I currently have 1 subscription pulling from this server, but I can't add
any new pull subscriptions, I receive an error message:
From EM, on Choose Publication (Using Wizard) - Click the + next to the
server I want to pull from
Could not retrieve information about publications from Publisher
Error 208: Invalid object name 'sysextendedarticlesview'
I do see this view in some of the db's that are currently replicating, but
I'm not sure of where it's looking for the view in this particular instance,
as I have not gotten to the point of selecting a publication.
Did my Distribution db become corrupt in some way?
Any suggestions will be greatly appreciated.
|||I did as you instructed & recreated this view & other missing objects on each subscribing db. It worked, I now see the publications to pull.
Thanx! You're the best!!!!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:%23fBQ6y1CGHA.344@.TK2MSFTNGP11.phx.gbl...
You should find this view in the subscriber. You can copy it from another
database of the same version to this one. Open up the database in EM, locate
the view, right click on it and select copy. Then paste it into QA on the
subscriber.
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
"JLS" <jlshoop@.hotmail.com> wrote in message
news:O8h6N1wCGHA.344@.TK2MSFTNGP11.phx.gbl...
I cannot get a pull subscription to work at all, push works, anyone have any
suggestions as to why?
I currently have 1 subscription pulling from this server, but I can't add
any new pull subscriptions, I receive an error message:
From EM, on Choose Publication (Using Wizard) - Click the + next to the
server I want to pull from
Could not retrieve information about publications from Publisher
Error 208: Invalid object name 'sysextendedarticlesview'
I do see this view in some of the db's that are currently replicating, but
I'm not sure of where it's looking for the view in this particular instance,
as I have not gotten to the point of selecting a publication.
Did my Distribution db become corrupt in some way?
Any suggestions will be greatly appreciated.