MSSQL kill Process)

Kill

Refer:
/*
Disable User-opened process Processing
*/
Create proc killspid (@ dbname varchar (20 ))
As
Begin
Declare @ SQL nvarchar (500)
Declare @ spid int
Set @ SQL = 'Clare getspid cursor
Select spid from sysprocesses where dbid = db_id (''' + @ dbname + ''')'
Exec (@ SQL)
Open getspid
Fetch next from getspid into @ spid
While @ fetch_status <>-1
Begin
Exec ('Kill '+ rtrim (@ spid ))
Fetch next from getspid into @ spid
End
Close getspid
Deallocate getspid
End

-- Usage
Use master
Exec killspid 'database name'