--查詢鎖死的表
   select blocked
from (select * from sysprocesses where blocked>0 ) a
where not exists(select * from (select * from sysprocesses where blocked>0 ) b
where a.blocked=spid)

--查詢鎖死的表詳情
DBCC INPUTBUFFER(98)  
--干掉鎖死的表
kill 98