SQL Server : What is running right now?

SQL 2000

select * from master.dbo.sysprocesses where status <> 'sleeping'

SQL 2005+

select * from sys.sysprocesses where status <> 'sleeping'

Easier by far, use Adam Machanic's 'Who is Active'

• sp_whoisactive 

PS : I've told you twice now!