Home Forums SQL Server 2005 SQL Server 2005 General Discussion The INSERT statement conflicted with the FOREIGN KEY constraint(Not reproducible) RE: The INSERT statement conflicted with the FOREIGN KEY constraint(Not reproducible)

  • August 17, 2009 at 2:59 pm

    #1040515

    anki_bakshi (8/17/2009)

    I am wondering do indexes on the table play part in this FK constraint violation error.

    I have a unique index on DocumentChild2(Document_GID,Child2_name).

    Nope, you'd get a unique index/constraint violation error.

    Was the FK on DocumentChild1 created AFTER there was data in the table? If to there could be "bad" data in the table if the constraint was created with the NOCHECK option

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question