移除sql数据所有链接用户
标签：end mes 链接 -- kill sse uri pen close
移除sql数据所有链接用户
go
declare @temp nvarchar(20)
declare myCurse cursor
for
select spid
from sys.sysprocesses
where dbid=DB_ID(‘数据库名称‘)--待清理的数据库
open myCurse
fetch next from myCurse into @temp
while @@FETCH_STATUS=0
begin
exec(‘kill ‘+ @temp)
fetch next from myCurse into @temp
end
close myCurse
deallocate myCurse;