sqlserver 判断某个进程是否锁表
查询连接该库的进程中所否被锁定
select * from master..sysprocesses where blocked>0 and dbid=db_id('数据库名');
kill被锁的spid
exec ('kill spid')
查询连接该库的进程中所否被锁定
select * from master..sysprocesses where blocked>0 and dbid=db_id('数据库名');
kill被锁的spid
exec ('kill spid')