I have some t-SQL code that is looking for any table returns, however if the row returned are greater that 0 it is a upper error.
It is all working great, however when the channel limits are OFF and i check it now, the Message column returned the SQL name, which is what want, however when i turn on channels i get a "1 is greater than 0" message.
I tried %LastMessage and %Message, but nothing works.
How can i display the same value in the message field, even when alerting???