SQL istenilen SQL bağlantısını yoketme silme

DECLARE @v_spid INT
DECLARE c_Users CURSOR
   FAST_FORWARD FOR
   SELECT SPID
   FROM master..sysprocesses (NOLOCK)
   WHERE spid>50 and --blocked>0 and
   dbId=(Select database_id from master.sys.databases where name='user database' )
   and hostname='istemci adı' and loginame='giriş yapan kullanıcı' and program_name='kullanan uygulama'
   --and spid=istenilen sesion ID  --AND status='suspended' --kilitleyen idleri atabiliriz
   --AND DATEDIFF(mi,last_batch,GETDATE())>=60
   AND spid<>@@spid

OPEN c_Users
FETCH NEXT FROM c_Users INTO @v_spid
WHILE (@@FETCH_STATUS=0)
BEGIN
  PRINT 'KILLing '+CONVERT(VARCHAR,@v_spid)+'...'
  EXEC('KILL '+@v_spid)
  FETCH NEXT FROM c_Users INTO @v_spid
END

CLOSE c_Users
DEALLOCATE c_Users