SQL Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 71 - XML parsing error: An Invalid character was found in text content

Issue in SQL Server :

Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 71XML parsing error: An Invalid character was found in text content.

Resolution :

Change the parameter as Text/CHAR/VARCHAR to NText/NCHAR/NVARCHAR