title: Sql Server 2000 - How can I find out what stored procedures are running currently?
body: <p>I'd like to know what stored procedures are currently running to diagnose some performance problems. How can I find that out?</p>