SQL Server Error Msg 2201 – %sDerivation from “anySimpleType” by restriction is not permitted, and derivation by restriction from a type derived from “anySimpleType” by extension is allowed only if no constraining facets are specified.

In this blog post, let’s learn about the error message “2201 – %sDerivation from “anySimpleType” by restriction is not permitted, and derivation by restriction from a type derived from “anySimpleType” by extension is allowed only if no constraining facets are specified.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

2201 – %sDerivation from “anySimpleType” by restriction is not permitted, and derivation by restriction from a type derived from “anySimpleType” by extension is allowed only if no constraining facets are specified.

Reason for the Error

To be update soon…

Solution

To be update soon…