tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

usp_whatsup error Msg 6841, Level 16, State 1, Line 1

Open d-moloney opened this issue 5 years ago • 1 comments

I tried out usp_whatsup on a SQL 2016 (13.0.5337.0) received the error.

Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()' because it contains a character (0x0000) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

d-moloney avatar Jun 20 '19 11:06 d-moloney

Pls see final comment in #140 / #150.

mjkirkpatrick avatar Jun 20 '19 20:06 mjkirkpatrick