SQL Server Error Msg 6986 – Invalid restriction for type ‘%s’. The effective total range of the model group in the restricted type must be a valid restriction of the occurrence range of the wildcard in the base type.

In this blog post, let’s learn about the error message “6986 – Invalid restriction for type ‘%s’. The effective total range of the model group in the restricted type must be a valid restriction of the occurrence range of the wildcard in the base type.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6986 – Invalid restriction for type ‘%s’. The effective total range of the model group in the restricted type must be a valid restriction of the occurrence range of the wildcard in the base type.

Reason for the Error

To be update soon…

Solution

To be update soon…