Use Master
Select Spid 'Session ID', Nt_UserName 'User Name',HostName 'Machine Name', SysProcesses.dbid 'DB id', sysdatabases.name 'Database Name', LogiName 'Logon Name', Program_Name Application, Convert(VarChar(30), login_Time, 100) 'Time Stamp'
From SysProcesses 
INNER join sysdatabases on SysProcesses.dbid=sysdatabases.dbid
where Nt_UserName Not In ('sa', 'System') And LogiName <> 'sa' 
order by name