SELECT @@SERVERNAME
go
SELECT @@VERSION
go
--select process
SELECT spid, kpid, blocked
, CAST(waittime AS BIGINT) as waittime, lastwaittype, waitresource, dbid, uid
, CAST(cpu / 1000 AS BIGINT) as cpu
, CAST(physical_io AS BIGINT) as physical_io, memusage, login_time , last_batch , ecid
, CAST(open_tran AS BIGINT) as open_tran, status, hostname, program_name
, hostprocess, cmd, nt_domain, nt_username, net_address, net_library, loginame, stmt_start, stmt_end
FROM master.dbo.sysprocesses
where hostprocess <>
