Constraint violation in a trusted constraint
From comments:
This might happen due to the the value physically written on the page being incorrect (data corruption). Or a bug in the product (probably less likely but possible). Run DBCC CHECKDB to see if that finds any issues. – Martin Smith Jun 18 '16 at 0:07
3
Along Martin's comment - did the data get into the table via MERGE? Here is one bug (closed as &quot;Won't Fix&quot;) that can do exactly this, and another bug (also &quot;Won't Fix&quot;). If you need more reasons to avoid MERGE, see this article. – Aaron Bertrand♦ Jun 18 '16 at 3:21