Q6.6: How do I find the oldest open transaction?

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