Update partition view causes TAB Lock for all partition tables

• Leo Leong

  SSCommitted

  Points: 1615

  More actions

  August 2, 2006 at 7:51 pm

  #115006

  Does anyone has any idea why code below will cause TAB lock to all my partition tables?

  UPDATE tbl_Partition1

  FROM v_Partition t1, tbl_JoinTable t2

  WHERE t1.partitionKey = myPartitionKey

  AND t1.key = t2.key

  I am updating my partition table. However, I need to use my partition view to join with another table in order to give me some result.

  This query locks all my partition tables. (let say, I have 5 partition tables)

  Thanks.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  August 2, 2006 at 11:21 pm

  #652992

  What are you trying to update?

  UPDATE tbl_Partition1

  SET ?????? = ?????

  FROM v_Partition t1

  INNER JOIN tbl_JoinTable t2 ON t1.key = t2.key

  WHERE t1.partitionKey = tbl_Partition1.myPartitionKey

  _____________
  Code for TallyGenerator