Killing all processes

Discussion in 'Databases' started by nickjason, Jul 19, 2009.

0
  1. #1
    CREATE PROCEDURE [dbo].[KILL_ALL_PROCESSES]
    @DBName VARCHAR(20)
    AS
    BEGIN
    DECLARE @SPid INT
    DECLARE MY_CURSOR CURSOR FAST_FORWARD FOR
    SELECT SPId FROM MASTER..SysProcesses
    WHERE DBId = DB_ID(@DBName) AND SPId <> @@SPId
    OPEN MY_CURSOR
    FETCH NEXT FROM MY_CURSOR INTO @SPId
    WHILE @@FETCH_STATUS = 0
    BEGIN
    EXEC('KILL ' + @SPId)
    FETCH NEXT FROM MY_CURSOR INTO @SPId
    END
    CLOSE MY_CURSOR
    DEALLOCATE MY_CURSOR
    END


    hehe im new here...hope this are useful
     
    nickjason, Jul 19, 2009 IP