Kill Script

Kill Script:

DECLARE @cmdKill VARCHAR(50)

DECLARE killCursor CURSOR FOR

SELECT 'KILL ' + Convert(VARCHAR(5), p.spid)

FROM master.dbo.sysprocesses AS p

WHERE db_name(p.dbid) like 'Your_DBname%'

OPEN killCursor

FETCH killCursor INTO @cmdKill

WHILE 0 = @@fetch_status

BEGIN

EXECUTE (@cmdKill)

FETCH killCursor INTO @cmdKill

END

CLOSE killCursor

DEALLOCATE killCursor