You don't mean Task Manager, do you?
If you mean something like Current Activity in EM there is a really good script for a sp here:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=135&lngWId=5
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]