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 <>