Hi,

I installed the package after reading the instructions, but I could not execute the Health Report.

It generated the following error:

Msg 213, Level 16, State 7, Procedure sp_replmonitorhelppublication, Line 322

Column name or number of supplied values does not match table definition.

After some digging I found that the problem is on section /* Replication Publisher */of the rpt_HealthReport stored procedure.

More specifically, the TEMP table #PUBINFO is populated with the output of sp_replmonitorhelppublication (on the distribution db) but it lacks the last column named publisher.

I added the missing column with a single line

[highlight="#ffff11"],publisher NVARCHAR(128) -- due to inconsistency with sp_replmonitorhelppublication's outut[/highlight]

right after line 998 on rpt_HealthReport and the Health Report was generated without any issue!

* DON'T FORGET THE COMMA AT THE BEGINNING

My SQL version is Microsoft SQL Server 2012 (SP3-GDR) (KB3194721) - 11.0.6248.0 (X64)

I will also test it on 2008R2 to see if the same tweak is needed.

Thanks for the great tool!