When trying to update the accessFlag for an exisiting ENTRoleCapability record, the following error displays.

Violation of UNIQUE KEY constraint 'IX_RoleCapability'. Cannot insert duplicate key in object 'ENTRoleCapability'.
The statement has been terminated.

I executed the ENTRoleCapabilityUpdate stored procedure directly..receiving the same error.

The table create SQL that I downLoaded would not compile unless I commented out all instances of the code below.

/* WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON),*/

The IX_RoleCapability has two constraints that contain this. I don't know this level of the SQL. I'm not sure how to compile the WITH statements successfully??

The prob that you are running into is because IX_RoleCapability is a Key field used to link two tables together. So you should examine the linked tables.

Without looking at it I would guess it links to ENTRole and ENTCapability. Find the listed Ids for the table and adjust those first and this linking table last.

I verified the ENTRole , ENTRoleCapability and ENTCapability keys all matched...I then truncated the ENTRoleCapability table to ensure that
it would insert a single record. This worked.

When I then edited the accessFlag, the IX_RoleCapability failure error still gets thrown.

Do you have a Table create SQL that differs from what I list below???

I downloaded the Table create sql and was unable to compile the ENTRoleCapability table create...unless I commented out the
commented out all instances of the code below.

/* WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON),*/

The IX_RoleCapability has two constraints that contain this. I don't know this level of the SQL. I'm not sure how to compile the WITH statements successfully??