SELECT  U.name AS UserName
        ,U.status
        ,U.createdate
        ,U.updatedate
        ,U.hasdbaccess
        ,P.name AS LoginName
        ,P.is_disabled
        ,P.type_desc
        ,P.default_database_name
        ,P.create_date
        ,P.modify_date
FROM    MyDB.sys.sysusers AS U
LEFT OUTER JOIN master.sys.server_principals AS P ON U.sid = P.sid
WHERE   U.islogin = 1
ORDER BY UserName;