we are on sharepoint 2010. When I query the Userinfo table in the content database, there is one user that has tp_deleted = 0 and tp_IsActive = 1 but this user does not show up in the User Information List either via
http://sitecolleaction/_catalogs/users/simple.aspx or with get-spuser.
I found that this user has a tp_ID that matches another user.
My first question would be how can two different users have the same tp_ID when that Id is used for group membership relations? we have multiple instances where two users share an ID.
second, is it possible to remove this row in anyway besides SQL?