wearediagram.com /terminating-sql-server-blocking-processes [code lang=”sql”] sp_who2 sp_lock USE yourdatabase; GO SELECT * FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID() AND resource_associated_entity_id = OBJECT_ID(N’dbo.yourtablename’); [/code] ]]>