Hi,

I had same problem about orphaned users, i just ran update query on the sysusers table for all the databases for orphaned users to update their sid to correct one, but it's not advisable to update system table directly until you know about it. so it is preferred to use sp_change_users_login.

One problem i am facing regarding orphaned users is, i can't see orphaned users in enterprise manager on my computer. But my collegue can see orphaned users in databases. How this can happen? Is there any way I can see orphaned users in my enterprise manager too? It shows up after it fix the logins. Any ideas?