Finding Table locks

  • Hi,

    Could you please help me to find the names of the tables that are being locked by any other process.

    I'm looking for a query which lists out all locked tables.

    Thanks in advance

    - Srikanth

  • Take a look at sys.dm_os_wait_stats. See if that will do what you need.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Take a look at sys.dm_tran_locks


    * Noel

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

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