查询发生死锁的表
SELECT request_session_id spid ,
OBJECT_NAME(resource_associated_entity_id) tableName
FROM sys.dm_tran_locks
WHERE resource_type = ‘OBJECT‘
数据库当前链接
select top 1000 *
from sys.dm_exec_connections
go
杀死某一会话
kill sessionid
原文：http://www.cnblogs.com/yuanlianxi/p/4744750.html