In this blog post, let’s learn about the error message “6979 – Invalid restriction for type ‘%s’. The element in the restricted type must have the same name as and a more restrictive type than the corresponding element in the base type.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
6979 – Invalid restriction for type ‘%s’. The element in the restricted type must have the same name as and a more restrictive type than the corresponding element in the base type.
Reason for the Error
To be update soon…
Solution
To be update soon…