sp_who2 con timer

spwho_loop.sql

 DECLARE @table TABLE
  (
      SPID        INT
     ,Status      VARCHAR(15)
     ,[Login]     VARCHAR(30)
     ,HostName    VARCHAR(MAX)
     ,BlkBy       VARCHAR(10)
     ,DBName      VARCHAR(15)
     ,Command     VARCHAR(MAX)
     ,CPUTime     INT
     ,DiskIO      INT
     ,LastBatch   VARCHAR(MAX)
     ,ProgramName VARCHAR(MAX)
     ,SPID_1      INT
     ,REQUESTID   INT
  )

WHILE 1 = 1
  BEGIN
      SET nocount ON

      DELETE FROM @table

      INSERT INTO @table EXEC SP_WHO2

      SELECT SPID
            ,BlkBy
            ,[Status]
            ,CPUTime
            ,Command
            ,DiskIO
            --,[Login]
            --,HostName
            ,DBName
            ,ProgramName
            ,LastBatch
            --,SPID_1
            --,REQUESTID
      FROM   @table
      WHERE  --Status != 'sleeping' AND
        --NOT ProgramName like 'SQL Server Profiler%' AND
        DBName = 'OKW'
      ORDER  BY CPUTime DESC
               ,BlkBy
               ,[Login]
               ,ProgramName

      SET nocount OFF

      WAITFOR DELAY '00:00:05'
  END