John Mitchell-245523 (12/16/2011)
Marco V (12/16/2011)
if you now check the properties of the user on the database it will have his login mapped nowWhat, even though there were 0 users fixed? My guess is that the OP has taken it literally and tried to change the user "user". Like I said, though, don't use this - it's deprecated. ALTER USER is the preferred command, and has the advantage that it works for Windows as well as SQL logins.
John
true, iam still using it as a habit from the past
anyways his typo in the alter login
ALTER USER [ram] WITH LOGIN = [ram]
Edit remove the []
ALTER USER ram WITH LOGIN = ram