fix login for sql 2005

[timc]

I have a sql2005 db I moved from server A to server B. There was a login called grievuse that was a sql login that was assigned as dbo and data read and write. I added the grievuse to server b, but I can only add the login to the server. WHen I try to map this user to the db user it tells me 15023 user already exists. In sql 2000 there was a sp_fixlogin I could use to do this. Is there an equivalent in 2005

[rmiao]

If it's regular sql login, you can remap it to db user with sp_change_users_login.

[timc]

Thanks that worked