Post reply

Locking on parent record

  • August 8, 2003 at 6:18 am

    #59301

    If there is a foreign key relationship between table A and table B, SQLserver will hold a lock on the parent record of table B when you do an update on the child in table A.

    Will this lock also happen when in the update the old value = new value for the foreign key column ?

  • August 8, 2003 at 11:50 pm

    #469283

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply