select h.spid, u.name, p.cmd, h.name, h.starttime,

p.hostname, p.hostprocess, p.program_name

from master..syslogshold h,

master..sysprocesses p,

master..sysusers u

where h.spid = p.spid

and p.suid = u.suid

and h.spid != 0 /* not replication truncation point */