Getting information about aliases

To display information about aliases, use sp_helpuser. For example, to find the aliases for “dbo,” execute:

sp_helpuser dbo
Users_name     ID_in_db    Group_name   Login_name
----------     --------    ----------   ----------
dbo            1           public       sa

(1 row affected)
Users aliased to user.
Login_name
----------------------
andy
christa
howard
linda

(4 rows affected)