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..