Replication: Replication Monitor only shows a red X after upgrading from SQL 2000 SP4 to SQL 2008 SP1

  • Article

Problem:

When I upgrade my SQL Server 2000 SP4 to SQL 2008 SP1, I am unable to verify my replication using Replication Monitor as it only shows a red X.

I remove and re-add the publisher but still obtain the same result.

Cause / Workaround:

The issue at hand is due to the fact that the table sp_replicationmonitordata was created to not allow nulls.

Workaround would be:

1. Drop/Create the table to allow the columns to allow nulls – beforehand you should generate the script for this table.
2. Execute the upgrade stored procedure: sp_vupgrade_replication –> this should be the best option as this is the stored procedure that was created to upgrade replication