user is not in db user table but it is in sysxlogins table
Posted on 2009-05-06
One user login it is in sysxlogins but It is not in the db user table, how can I
map this user from sysxlogins to user table? it was in db user table before.
EXEC sp_change_users_login 'Report', ( this user is not in report list)
EXEC sp_change_users_login 'Auto_Fix', 'LLCK\usr1'
EXEC sp_change_users_login 'Auto_Fix', 'usr1', ''LLCK\usr1'', 'password'
but none of work. Please help!!!!