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)
