可以设置手动删除
declare @kill varchar(8000) = '';
select @kill=@kill+'kill '+convert(varchar(5),spid)+';'
from master..sysprocesses
where dbid=db_id('TEST_DBNAME');
exec (@kill);
可以设置手动删除
declare @kill varchar(8000) = '';
select @kill=@kill+'kill '+convert(varchar(5),spid)+';'
from master..sysprocesses
where dbid=db_id('TEST_DBNAME');
exec (@kill);
转载于:https://www.cnblogs.com/DBArtist/p/4661257.html