get process with filters in who2

 SELECT  spid,

        sp.[status],

        loginame [Login],

        hostname, 

        blocked BlkBy,

        sd.name DBName, 

        cmd Command,

        cpu CPUTime,

        physical_io DiskIO,

        last_batch LastBatch,

        [program_name] ProgramName   

FROM master.dbo.sysprocesses sp 

JOIN master.dbo.sysdatabases sd ON sp.dbid = sd.dbid

where sd.name='sss' and sp.[status] <> 'running'

ORDER BY spid 

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email