CREATE PROCEDURE KillSpid(@dbName varchar(20))
AS
BEGIN
    DECLARE @sql nvarchar(500)
    DECLARE @spid int
    
    SET @sql=‘DECLARE getspid CURSOR FOR 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 ‘+@spid)
        FETCH next FROM getspid INTO @spid
    END
    CLOSE getspid
    DEALLOCATE getspid
END
GO