use masterdeclare @dbname varchar(20)set @dbname='Bname'declare @sql nvarchar(500)declare @spid int--SPID 值是當用戶進行連接時指派給該連接的一個唯一的整數set @sql='declare getspid cursor forselect spid from sysPRocesses where dbid=db_id('''+@dbname+''')'exec (@sql)open getspidfetch next from getspid into @spidwhile @@fetch_status<>-1--如果FETCH 語句沒有執行失敗或此行不在結果集中。beginexec('kill '+@spid)--終止正常連接fetch next from getspid into @spidendclose getspiddeallocate getspid