sql 表插锁 解锁

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


--解锁
KILL 61

  

posted @ 2015-08-12 20:05  yufeiyunsui  阅读(147)  评论(0编辑  收藏  举报