I've looked, but can't find the procedure I developed. It's not too difficult, just copy the sp_who2 code to query analyzer, and make the changes to display the data you want.

I do find it interesting that many of the system sp's in SQL 2000 seem to use cursors and loops. 194 of the obejcts in master information_schema.routines contain the word cursor, while 45 contain the word loop. Maybe you need to go talk to MS about RBAR, Jeff!