SELECT * FROM sys.sysprocesses WHERE waittime >120000

Hi, will u plz tell when i try to run this query in sql 2000 its not working .Because in sql 2000 there is no dmv of sys.processes so will u plz tell me where can i look for this.Any suggestion ???
SELECT * FROM sys.sysprocesses WHERE waittime >120000
Thaxxx
jagpal singh

Hi,
When I ran the belwo query I got 4 records but what next should I do in order to get to the root cause of the problem
SELECT * FROM master.dbo.sysprocesses WHERE waittime >120000
my server's configuration is
Intel Xeon 2.8 GHZ, 2GB RAM, SQL 2K STD edition, 73 GB 15000 RPM SCSI HDD, Two database in simple recovery DB sizes around 12GB & 8 GB.
Any Suggestions,
Rohit

When I cross checke the same SP id through sp_who2 I got below result
6 BACKGROUND sa . . master TASK MANAGER 0 0 04/29 04:22:39 6
and the select statement give below record
6 0 0 0x0000 781813890 RESOURCE_QUEUE 1 1 0 0 3 2008-04-29 04:22:39.797 2008-04-29 04:22:39.797 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0
Command is ran through Task Manager....I'm confused.

Rohit