%sInvalid source character 0x%02x

Error Message:
Msg 2333, Level 16, State 1, Line 4
%sInvalid source character 0x%02x

Severity level:
16.

Description:
This error message appears when in an XQuery an invalid source character was found.

Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.

Resolution:
Errors of the Severity level 16 are generated by the user and are corrigible by the user. The statement cannot be run this way. All characters must be valid.

Versions:
This error message was introduced with SQL Server 2005.

Example(s):
DECLARE @xml xml;
SET @xml = ”;
SELECT
    @xml.query(‘for $a in(1, 2, 3), $b in (¨2, 3)
    where
        $a lt $b
    return sum($a + $b)’) as XML;

Remarks:
In the above example we try to use the ¨ character. This is an invalid source character and the error is raised.