Super sp_who for SQL 2005

Uses DMVs and shows statement text.

SELECT req.session_id
       , req.blocking_session_id
       , req.cpu_time
       , req.Reads
       , req.writes
       , req.logical_reads
       , sess.login_time
       , conn.last_read
       , conn.last_write
       , sess.host_name
       , conn.client_net_address
       , sess.program_name
       , db_name(req.database_id) As databasename
       , stmt.text As command_text
       , req.status
FROM   sys.dm_exec_requests req
       INNER JOIN sys.dm_exec_connections conn
         On req.session_id = conn.session_id
       INNER JOIN sys.dm_exec_sessions sess
         ON req.session_id = sess.session_id
       CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS STMT
WHERE  req.session_id >= 51