SqlServer查询和Kill进程死锁的语句

查询死锁进程语句

select 
request_session_id spid, 
OBJECT_NAME(resource_associated_entity_id) tableName 
from 
sys.dm_tran_locks 
where 
resource_type='OBJECT' 

查看更多关于SqlServer查询和Kill进程死锁的语句的详细内容...