Home Forums SQL Server 2005 Development Cannot insert duplicate key row in object with unique index on duplicate foreing key RE: Cannot insert duplicate key row in object with unique index on duplicate foreing key

  • looks like there is a constraint to not allow duplicates in the table that is referring to fk_mfg_nb in your output in your comment, its a unique index so thus its not allowing another 64 in that column in that table, if it were 65 that you were inserting it would allow it...option is to include another column that will make it unique or change the value to 65 to have the ability to insert it