>I have a SQL command that I cannot execute from my application. The message is:
>
>"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
>
>However, if I execute that SQL from SSMS, it works.
>
>So, I would like to know what it means exactly and why is it working from the SSMS environment?
Perhaps one of the settings is different such as SET ANSI_WARNINGS or ANSI_NULLS or ANSI_NULL_DEFAULT
If it's not broken, fix it until it is.
My Blog