I also found that you can't just query sysprocesses (unlike sysobjects), you have to specify sys.sysprocesses.