views:

246

answers:

1

Through some bungling in creating and removing publications, I was left with a lot of obsolete publications which for some reason still remains in the Replication Monitor.

How do you remove these publications? It doesn't seem to have a clear way to remove them.

A: 

This is an old question of mine, but then again at least I found a way to resolve it.

I was able to remove the publications is by creating a new publication with the same name, then delete the publication again. This time the publication will no longer appear in the Replication Monitor. I did not remember if the publication has to be the same type as the obsoleted one, but it works.

UPDATE: Okay, the publication type and database name is important, otherwise the newly created publication will be considered as a different publication. Kinda obvious, but now I'm sure of it.

alextansc