• You would have to run sp_resolve_logins for each and every database which would mean you would have to dump the sys.logins table for each and every database. That is likely to be a lot more work for the DBA than just syncing up the existing entries between the database and the instance.

    If you only have a couple of users to fix you could use sp_change_users_log to re-sync.

    -- Mark D Powell --