declare @i INT
declare cur cursor for select spid from sysprocesses where db_name(dbid)= 'Tmsdb-Test'
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
恩,以上就是强行关闭数据库连接了,要使用master数据库
其中 'Tmsdb-Test'就是要断开连接的数据库