>>Script Language and Platform: SQL SERVER
The following stored procedure(script) helps to kill all processes in a particular database
without current process.
Author: Shiva
Create Proc Sp_KillAllProcessInDB @DbName VarChar(100) as if db_id(@DbName) = Null begin Print 'DataBase dose not Exist' end else Begin Declare @spId Varchar(30) DECLARE TmpCursor CURSOR FOR Select 'Kill ' + convert(Varchar, spid) as spId from master..SysProcesses where db_Name(dbID) = @DbName and spId <> @@SpId and dbID <> 0 OPEN TmpCursor FETCH NEXT FROM TmpCursor INTO @spId WHILE @@FETCH_STATUS = 0 BEGIN Exec (@spId) FETCH NEXT FROM TmpCursor INTO @spId END CLOSE TmpCursor DEALLOCATE TmpCursor end --To Execute --Exec Sp_KillAllProcessInDB [DBName]
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
"as -is", without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose...
Disclaimer Continued
Back to Database Journal Home