SQL Server Error Msg 6829 – FOR XML EXPLICIT and RAW modes currently do not support addressing binary data as URLs in column ‘%.*ls’. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1=”V1″]/@COLUMN’ syntax.

In this blog post, let’s learn about the error message “6829 – FOR XML EXPLICIT and RAW modes currently do not support addressing binary data as URLs in column ‘%.*ls’. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1=”V1″]/@COLUMN’ syntax.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6829 – FOR XML EXPLICIT and RAW modes currently do not support addressing binary data as URLs in column ‘%.*ls’. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1=”V1″]/@COLUMN’ syntax.

Reason for the Error

To be update soon…

Solution

To be update soon…