• I donn think SQL server places lock on the parent table if the child table is being updated.If that is the case then there would be too much of load on the server.

    Correct me If I am wrong.

    Relationships are like Banks.You Invest the Principal and then get the Interest.


    He who knows others is learned but the wise one is one who knows himself.