杀掉数据库用户进程

/*还原数据库,杀死所有进程用 @dbname 指数据库名 */

create proc killspid (@dbname varchar(20))

as

begin

declare @sql nvarchar(500)

declare @spid int

set @sql='declare getspid cursor for 

select spid from master..sysprocesses where dbid=db_id('''+@dbname+''')'

exec (@sql)

open getspid

fetch next from getspid into @spid

while @@fetch_status<>-1

begin   

if (@spid <> @@spid) /*自己不用杀,@@spid表示自己*/

begin

exec('kill '+@spid)

end

fetch next from getspid into @spid

end