find locked tables

• marees.inspire

  Ten Centuries

  Points: 1324

  More actions

  February 4, 2009 at 4:01 am

  #126193

  hi all,

  how to find locked tables in sql server 2005

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  February 4, 2009 at 4:08 am

  #937805

  One option is to run "sp_lock" which returns a list of all the locks currently active.

  .

• marees.inspire

  Ten Centuries

  Points: 1324

  More actions

  February 4, 2009 at 4:53 am

  #937828

  Thank a lot