To be honest, I don't know and don't know where to look or how to check. All the data set stuff is hidden by the Mere Mortals framework, I just tell it what stored procedure to run and it creates the dataset.

>Does your DataSet has properly defined Primary Key?
>
>Also, I believe we discussed this exact error about a month or so ago with you before.
>
>>Hi,
>>
>>I changed the structure of a table in my SQL Server database and created a new stored procedure (which was a copy/paste/modify of an existing and working SP). This SP gets called to fill a dataset, but I get this error:
>>
>>Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
>>
>>Exception Details: System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
>>
>>Source Error:
>>
>>Line 411: {
>>Line 412: // Using GetDataSet will replace the DataSet
>>Line 413: this.FillDataSet(this.GetCurrentDataSet(),
>>Line 414: "PlansSelectByBasePlan");
>>Line 415:
>>
>>PlansSelectByBasePlan is my SP, defined like this:
>>
>>

CREATE PROCEDURE [dbo].[PlansSelectByBasePlan]
>>
>>AS
>>	SET NOCOUNT ON;
>>	SELECT [Code],
>>		[CommissionAccount],
>>		[CommissionFK],
>>		[CurrencyFK],
>>		[Description],
>>		[EffectiveDate],
>>		[IsARider],
>>		[IsAWaiver],
>>		[MaxAge],
>>		[MaxPremium],
>>		[MaxSumAssured],
>>		[MaxUnits],
>>		[MinAge],
>>		[MinPremium],
>>		[MinSumAssured],
>>		[MinUnits],
>>		[PlanAccount],
>>		[PlanPK],
>>		[PlanTypeFK],
>>		[UnitsInForce]
>>	FROM [dbo].[Plans]
>>	WHERE 
>>		([IsABasePlan] = 1)

>>
>>If I run the SP in SSMS it runs and returns the expected data. Any ideas what this problem is?