print '====[WORKING : ZLO]======================================================================================'
DECLARE ZLO CURSOR
FOR 
select 
  SDB.name	   as DB,
  SSP.spid	   as SPID,
  SSP.hostname     as HOST,
  SSP.program_name as PROGZ,
  SSP.loginame     as LOGIN
from 
  dbo.sysprocesses SSP
    inner join
  dbo.sysdatabases  SDB
    on SSP.dbid=SDB.dbid
where 
  SDB.name in ('GSKEKB','GSKNSK','SHOPNEW') and   --название серверов
 
  SSP.hostname <> 'PC122'  --сетевое имя машины
 

DECLARE 
  @Login varchar( 40 ),
  @Host  varchar( 40 ),
  @Progz varchar( 40 ),
  @DB    varchar( 40 ),
  @Spid  int,
  @SQL   nvarchar( 2000 )

OPEN ZLO

FETCH NEXT FROM ZLO 
  INTO @DB,@Spid,@Host,@Progz,@Login
WHILE (@@fetch_status <> - 1 )
BEGIN
	IF (@@fetch_status <> - 2 )
	BEGIN
         select @SQL = 'kill '+cast(@Spid as varchar( 5 ))
         exec sp_executesql @SQL
	 print 'kicked uzwer : '+cast(@Spid as varchar( 5 ))+'/'+RTRIM(LTRIM(@Host))+' from ['+RTRIM(LTRIM(@DB))+'] with login ['+RTRIM(LTRIM(@Login))+'] PROGA : ['+RTRIM(LTRIM(@Progz))+']'         
	END
	FETCH NEXT FROM ZLO 
          INTO @DB,@Spid,@Host,@Progz,@Login
END

CLOSE ZLO
DEALLOCATE ZLO
GO
print '====[END WORKING : ZLO]=================================================================================='