Hi,
I get the message "Failed to enable constraints. One or more rows
contain values violating non-null, unique, or foreign-key constraints."

All the keys are intact and this problem pops up when there is a
dataset.merge(dataset).

The has errors gives false and the geterrors returns nothing.

can some one throw some light?
Thanks
Sri

Solved it. How ever, it is not easy to zero down on the problem.

1. Check the tables in all the datasets
2. check the stored procs
3. run the stored procs.. In most cases, the triggers behind the tables
or the stored procs inside the stored procs are the culprits.

What is the quickest/most efficient way to insert 100,000 Rows
Advatages of Stored Procedures?
Sql Server SCOPE_IDENTITY()
"Business Objects" and the DAL
A severe error occurred on the current command. sp_AddMergePublication