select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)table_news from sys.dm_tran_locks
where resource_type = 'OBJECT '
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)table_news from sys.dm_tran_locks
where resource_type = 'OBJECT '
转载于:https://www.cnblogs.com/laoqiang/archive/2008/03/27/1124640.html