I am creating a procedure (replaceCommaTest.sql) that will change instances of ',' (comma) with ';' (semicolon).
I have a trigger on the table (see createAuditTrigger.sql).
When I run the procedure I get this message:
Msg 9420, Level 16, State 1, Procedure EnvironmentChangeAudit, Line 46
XML parsing: line 1, character 5340932, illegal xml character
If I delete the trigger and run the procedure, every works fine.
Also, if I do a single insert statement with the trigger in place, the trigger works fine.
Any idea what is going on and how to fix the problem