How do i know which process using my particular table ?

• amrishy2k

  Grasshopper

  Points: 20

  More actions

  August 4, 2009 at 2:21 pm

  #224590

  Hi,

  I have a one major table in my database. And number of process using this table.

  How do i knwo which process (spid) is using this table.

  Thank you,

  Regards,

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 5, 2009 at 4:01 am

  #1034677

  Try this:

  select *

  from sys.dm_tran_locks

  where resource_database_id = db_id()

  and resource_type = 'OBJECT'

  and resource_associated_entity_id = object_id('MyTable')

  -- Gianluca Sartori