Posted on
2007-12-01 21:27新人~
阅读(378)
评论(0)
编辑收藏举报
断开所有数据库连接
createproc killspid (@dbnamevarchar(20)) as begin declare@sqlnvarchar(500) declare@spidint set@sql=’declare getspid cursorfor select spid from sysprocesses where dbid=db_id(’’’+@dbname+’’’)’ exec (@sql) open getspid fetchnextfrom getspid into@spid while@@fetch_status<>-1 begin exec(’kill ’+@spid) fetchnextfrom getspid into@spid end close getspid deallocate getspid end --用法 use master exec killspid ’数据库名’