I have been using dbwarden for the past five years...including through an upgrade from sql2008 to sql2012r2. A couple of weeks ago, SQL2012 service pack 4 came out and wrecked the dbwarden health report. Its run fine on any node that does not have the service pack installed - but those (nearly all our production servers) that have it will not run it anymore with this error:
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Column name or number of supplied values does not match table definition. [SQLSTATE 21S01] (Error 213). The step failed.
Given that I'm a network/server/security admin and dba by default, i'm having the hardest of times trying to figure out what table column name or number value doesn't match what table definition. Some indicators seem to point to a discrepancy between the dbwarden table columns and the temp table? Anyone else having this issue and how did you resolved it?
Hi, please find the solution in the entry above: https://www.sqlservercentral.com/Forums/FindPost1847505.aspx
With SQL 2017 there is another adjustment needed.
In the temporary table #REPLINFO need to be added two more fields at the end.
[deletebatchsize_xact] int,
[deletebatchsize_cmd] INT
Then the health report works again.
Regards,
Volker