select * from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = DB_ID('数据库名')
select OBJECT_NAME(sys.dm_tran_locks.resource_associated_entity_id) from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = DB_ID('数据库名')
--requst_request_id
KILL xx
select OBJECT_NAME(sys.dm_tran_locks.resource_associated_entity_id) from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = DB_ID('数据库名')
--requst_request_id
KILL xx