Hi,

even I have my instance in preferred node, still i received an email stating "@subject = 'Preferred Node has Changed',"

Do...

Can you please help me if my instance is on right node then it should say instance is on preferred node, no action is necessary?

Got an error.

Msg 22050, Level 16, State 1, Line 0
Error formatting query, probably invalid parameters
Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 517
Query execution...