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 5:44 pm

    #1040588

    No, the FK on DocumentChild1 was created at the time of table creation.

    Can multiple asynchronous inserts in the Document table can cause this behavior? I mean may be the index page where the concerned GID is located is locked by the Insert sql as it is also inserting into the same page.