How to remove orphan Red Xs?

• Mindy Hreczuck

  SSCommitted

  Points: 1796

  More actions

  January 12, 2006 at 8:09 am

  #96435

  I have a QA machine on which a previous publication and merge agents from a merge replication scenario were removed piecemeal. When I browse down Replication Monitor I have no publications or agents as expected, however the Merge Agent folder and upwards have a red X on them still. Where is this status stored? Can I clean it out manually?

  Similarly, I'll sometimes run into a hanging "db:db" publication when the database has been removed and the system tables still think there's a publication somewhere. Deleting it errors that it can't retrieve the information about publication "db:db" Error 2812: Could not find stored procedure." Again I figure there's a system setting I can update to correct the status, but I'm not sure where it is, or how many tables I have to go through.

   

  Thanks for any input.

   

• Hilary Cotter

  SSCommitted

  Points: 1861

  More actions

  January 13, 2006 at 4:02 am

  #614568

  sp_MSload_replication_status

  --

  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