How to Check some table was locked

select * from sys.sysprocesses where blocked<>0

 看看waittime是不是很大 

kill spid

posted @ 2013-07-30 19:22  Vincent.Dr  阅读(142)  评论(0)  编辑  收藏  举报