强制断开sql server数据库已有连接的方法

时　间:2018-08-22 08:13:21
作　者:宏鹏   ID：21115  城市：上海
摘　要:强制断开sql server数据库已有连接的方法 
正　文:

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

为了方便，可以把这条sql写到建库的批处理脚本里，放在脚本的开始

:: Disconnect existing Fortune database connectionsosql -S"%1" -U"%2" -P"%3" -Q"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"

另外，分离数据库时，选择切断所有的连接，也是一种办法。