sp_helpmaplogin displays mapping information:
sp_helpmaplogin [ (authentication_mech | null), (client_username | null) ]
where:
client_username – is an external user name.
If you do not include any parameters, sp_helpmaplogin displays login information about all users currently logged in to Adaptive Server. You can restrict the output to specific sets of client user names or authentication mechanists by using the parameters listed above.
This displays information about all logins:
sp_helpmaplogin
authentication client name login name -------------- ----------- ------------------ NULL jsmith guest LDAP NULL create login