I have a database with an XML column. During the course of normal operations, a record was inserted into this table which completed successfully. However, when we run a report on this table and attempt to select the data back out of that column,
we receive the following error:
From the a stored procedure -
Msg 6611, Level 16, State 1, Procedure shrrptAuditReport, Line 19
The XML data type is damaged.
From a select against the table -
An error occurred while executing batch. Error message is: '?', hexadecimal
value 0xDC29, is an invalid character. (NOTE: The ? actually appears as a square in SSMS)