Forum Discussion

KCheng_159013's avatar
KCheng_159013
Icon for Nimbostratus rankNimbostratus
Jul 01, 2014

MSSQL Health Monitor - Longer than 1 standard line

Hey guys,

 

Just wondering if anyone has come across the issue when using an MSSQL heath monitor where the SEND String is longer than 1 standard line therefore resulting in the 'Value may not contain literal newline characters.' error when saving?

 

If so does anyone know how to get around this? I have a SQL query which I have removed out all whitespaces except spaces but is longer than 1 standard line.

 

I have tried putting \n which doesnt work as it interferes with the query and I've also tried escaping it by using \n which also doesnt work as the above error pops up again.

 

My query has some inner joins and also a case statement which is why its a tad longer.

 

Thanks heaps.

 

Karen

 

3 Replies