在master数据库中执行如下代码
www.2cto.com
Sql代码
declare @i INT
declare cur cursor for select spid from sysprocesses where db_name(dbid)= 'Your_Database_Name'
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