SQL Server Error Msg 6981 – Invalid restriction for type ‘%s’. The element in the restricted type may not be nillable if the corresponding element in the base type is not.

In this blog post, let’s learn about the error message “6981 – Invalid restriction for type ‘%s’. The element in the restricted type may not be nillable if the corresponding element in the base type is not.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6981 – Invalid restriction for type ‘%s’. The element in the restricted type may not be nillable if the corresponding element in the base type is not.

Reason for the Error

To be update soon…

Solution

To be update soon…