SQL Server Error Msg 6980 – Invalid restriction for type ‘%s’. The particle in the restricted type may not have an occurrence range more permissive than that of the corresponding particle in the base type.

In this blog post, let’s learn about the error message “6980 – Invalid restriction for type ‘%s’. The particle in the restricted type may not have an occurrence range more permissive than that of the corresponding particle in the base type.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6980 – Invalid restriction for type ‘%s’. The particle in the restricted type may not have an occurrence range more permissive than that of the corresponding particle in the base type.

Reason for the Error

To be update soon…

Solution

To be update soon…