From Books Online..
________________________________________________________
How to view current server activity (Enterprise Manager)
To view current server activity
Expand a server group, and then expand a server.
Expand Management, and then expand Current Activity.
Click Process Info.
The current server activity is displayed in the details pane.
________________________________________________________
You can also use the sp_who stored procedure to programmatically get info..
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________