table locks find

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  October 29, 2010 at 12:34 am

  #149167

  Hi,

  i used sp_lock to find the locked tables

  but i have 10 tables in a user db x

  suppose 1 ist table is linked with 2nd 3rd etc.. tables

  how to find out primary table which causing the other tables locks

  using sql server 2005 Enterprise edition

  & how to avoid the continuous table locks

  thanks in advance

• jamessdb

  Mr or Mrs. 500

  Points: 524

  More actions

  November 2, 2010 at 4:31 am

  #1245259

  please respond/reply for this issue