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:11 pm

    #1040480

    My transaction isolation level is READ_COMMITTED and yes, I am using nolocks while reading data from DocumentChild1. But, I have verified that no one is changing(Insert/Update/Delete) data in the DocumentChild1 during that time. Also, I had sql profiler enable when we saw this error. The rowcount suggests that the correct number of records being read from DocumentChild1.

    Thanks for your help.