–查看SQL事务隔离级别
DBCC Useroptions
–设置SQL事务隔离级别
set transaction isolation level Read Uncommitted
set transaction isolation level <隔离级别>
–查询锁表语句
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type=‘OBJECT’
–杀掉进程
kill spid