Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-06 : 08:30:23
|
| Rob writes "Ok I have searched everywhere and I am unable to find a solution. Here is the story:There where a few publications showing up in Replication Monitor that had no associated publication under the database it corresponded to. Basically when they where removed, they where not removed properly and it orphaned the publication in Replication Monitor. So now they are there with a red X going through them starting from Replication Monitor down to the actual failed publication. We cleared out the publication that where orphaned through the System Replication tables by clearing out the publication_id that corresponded to the publication. This cleared it out and now there is no error under Replication Monitor if you drill down to the publications or Agents, yet there is still a red X through Replication Monitor, Publishers, and Agents. This gives a false sense of an error even though there is not one. Please help... " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-06 : 12:23:38
|
| You probably will have to clear out rows in the distribution database.Tara |
 |
|
|
|
|
|
Incorrectly Show Replication Monitor As Failed