• sa might be mapped to a user. The login would be sa, the user something else.

    select

    u.name

    , s.name

    from sysusers u

    inner join master.dbo.syslogins s

    on u.sid = s.sid

    Steve Jones

    sjones@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net