Try posting to the 2000 forum. You'll get answers more suited to SQL Server 2000 than posting in the 2008 forum.
To identify the longest running queries back in 2000, I used a server-side trace with trace events.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning