Hi:
I removed the publication from the database but it is still showing in the monitoring tool. Does anyone know how to remove it from there?
Thanks
did you try refreshing? disconnect-reconnect?|||Yes I tried that but still does not work.
|||how did you remove the publication, and what version of sql server are you using?|||If replication is removed forcefully in publishing db, and distribution db is not accessible, it is possible to leave orphaned entries in some of the metadata tables at the distributor.
if this is SQL 2005, and you see publications in SQL Monitor that no longer exist, then you can try deleting the orphaned entries in table [MSpublications] in distribution db, as this is where SQL Monitor is retrieving the data from.
No comments:
Post a Comment