Replication Monitor

In SQL 2k, I recently found my replication monitor displays no subscriptions
in the tree = Replication Monitor > Server> Publication.
Where I could see all 50 + subscribers, now there is only a snapshot agent
showing. Yet all subscribers are happily synching away and visible in the
Replication Monitor > Agent > Merge tree.
This is real cumbersome to view. Any idea how to get my other view back,
grouped by publication ?
Thanks for your help.
Mike
If data falls in the woods and nobody is there to see it ...... ?
There is a condition where you add a publication with an identical name to a
different database on the same publisher which will cause this to happen.
You need to selectively delete publications until all the subscribers are
displayed 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
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:ED11F1FB-03AE-452A-99EE-8821FFDFB935@.microsoft.com...
> In SQL 2k, I recently found my replication monitor displays no
> subscriptions
> in the tree = Replication Monitor > Server> Publication.
> Where I could see all 50 + subscribers, now there is only a snapshot agent
> showing. Yet all subscribers are happily synching away and visible in the
> Replication Monitor > Agent > Merge tree.
> This is real cumbersome to view. Any idea how to get my other view back,
> grouped by publication ?
> Thanks for your help.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?
|||Thanks Hilary, probably a delete version of the same publication stuck in
there. Will see what I find. Appreciate the tip.
Mike
If data falls in the woods and nobody is there to see it ...... ?
"Hilary Cotter" wrote:

> There is a condition where you add a publication with an identical name to a
> different database on the same publisher which will cause this to happen.
> You need to selectively delete publications until all the subscribers are
> displayed 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
>
> "Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
> news:ED11F1FB-03AE-452A-99EE-8821FFDFB935@.microsoft.com...
>
>