Displaying password information

You use the sp_displaylogin system procedure to display password information for logins and roles.