SELECT sid, status, name, dbname, hasaccess, loginname FROM master.dbo.syslogins; GO SELECT spid, kpid, lastwaittype, waitresource, dbid FROM master.dbo.sysprocesses; GO...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/08/09/1334.aspx