--关闭用户进程处理

    declare @spid varchar(20)
    declare #spid cursor for
        select spid=cast(spid as varchar(20)) from master..sysprocesses where dbid=db_id(@dbname)
    open #spid
    fetch next from #spid into @spid
    while @@fetch_status=0
    begin  
        exec('kill '+@spid)
        fetch next from #spid into @spid
    end  
    close #spid
    deallocate #spid

USE master

db_id('educational') 

   declare @spid varchar(20)
    declare #spid cursor for
        select spid=cast(spid as varchar(20)) from master..sysprocesses where dbid=db_id(@dbname)
    open #spid
    fetch next from #spid into @spid
    while @@fetch_status=0
    begin  
        exec('kill '+@spid)
        fetch next from #spid into @spid
    end  
    close #spid
    deallocate #spid