dbcc opentrans tells me No active open transactions.

whereas the following query returns two rows

login name session_count

Adminstrator 3

sa 16

SELECT login_name ,COUNT(session_id) AS session_count

FROM sys.dm_exec_sessions

GROUP BY login_name;

oops and btw...sorry this is SQL 2005 not 2008