Wednesday, May 26, 2010

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Came across this error with a SQL Server 2005 sproc, being called via a Visual Studio 2008 xsd table adapter.

Check your data adapter tables, the sproc was missing 2 columns that the datatable was expecting in the results:

No comments:

Post a Comment