Hi all,
I recently started getting alerts from one of our sql servers where replication is set up - this is due to a publication that is listed in the replication monitor view in ent mgr, which when you right-click it to view its properties you get an error that it does not exist. I don't know where this publication came from as i never set it up, so i've tried to get rid of it manually as ent mgr wont allow me to delete it gracefully. The stored procs don't work either - keep getting the message that the publication doesn't exist. So i went through all the distribution db tables and found two entries relating to the "non" existent publication and deleted them. The publication has disappeared from the repl monitor view/snapshot agent view - but i still have the red cross from the previous time it failed. Anyone know how i can get rid of the error sign, as we have other publications which are working correctly and this will just confuse people.
Thanks
Div
I recently started getting alerts from one of our sql servers where replication is set up - this is due to a publication that is listed in the replication monitor view in ent mgr, which when you right-click it to view its properties you get an error that it does not exist. I don't know where this publication came from as i never set it up, so i've tried to get rid of it manually as ent mgr wont allow me to delete it gracefully. The stored procs don't work either - keep getting the message that the publication doesn't exist. So i went through all the distribution db tables and found two entries relating to the "non" existent publication and deleted them. The publication has disappeared from the repl monitor view/snapshot agent view - but i still have the red cross from the previous time it failed. Anyone know how i can get rid of the error sign, as we have other publications which are working correctly and this will just confuse people.
Thanks
Div