I have a SQL monitor that runs a SProc, returning two columns. The first column (statistic) is a count, and the second column (message) concatenates a string containing a list of items (up to three server names reported when -gt 0). When the results are 0, the monitor shows as up, but when the statistic is -gt 0, the monitor throws an error, Unable to Convert Query Results.
If I exec the SProc in SSMS, the results come back:
[1][server A]
I have other similar monitors that work this way, so I'm confused why this is throwing an error when the result for statistic is numerical.
Any ideas on what I'm missing or doing wrong?