declare @kid varchar(8000)
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8))
from master..sysprocesses
where dbid=db_id('库名')
Exec(@kid)
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8))
from master..sysprocesses
where dbid=db_id('库名')
Exec(@kid)
declare cur cursor for
select spid from sysprocesses where db_name(dbid)='dbname'
open cur
fetch next from cur into @i
while @@fetch_status=0
begin
exec('kill '+@i)
fetch next from cur into @i
end
close cur
deallocate cur
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8))
from master..sysprocesses
where dbid=db_id('库名')
if @kid<>'kill'
Exec(@kid)