SQL Server Error Msg 7893 – Parameter ‘%.*ls’:  Incompatible XML attributes were present.  The ‘%.*ls’ attribute and the ‘%.*ls’ attribute may not both be present on a parameter value node of type ‘%.*ls’ (in the namespace ‘%.*ls’).

In this blog post, let’s learn about the error message “7893 – Parameter ‘%.*ls’:  Incompatible XML attributes were present.  The ‘%.*ls’ attribute and the ‘%.*ls’ attribute may not both be present on a parameter value node of type ‘%.*ls’ (in the namespace ‘%.*ls’).” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

7893 – Parameter ‘%.*ls’:  Incompatible XML attributes were present.  The ‘%.*ls’ attribute and the ‘%.*ls’ attribute may not both be present on a parameter value node of type ‘%.*ls’ (in the namespace ‘%.*ls’).

Reason for the Error

To be update soon…

Solution

To be update soon…