Post reply

Deadlock occuring due to Schema Locks

  • April 15, 2014 at 5:03 am

    #306702

    Hi All,

    Here is the scenario, there are Parent and child table say Purchase_master and tmp_Purchase_info respectively.

    In a procedure(p1) i am dropping the child table "tmp_Purchase_info", simultenously there is an another procedure(p2) which is looking up some records from parent table "Purchase_master".

    Purchase_Master holds the Sch-S lock since its getting used in proc (P2).

    Now my question is while dropping child table will that cause Sch-M lock on parent table?

    Thanks in Advance!

  • April 15, 2014 at 6:17 am

    #1706058

    I don't think so.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 15, 2014 at 6:40 am

    #1706066

    Thanks, Any idea why this causing the deadlock?

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

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