sp fixlogin for sql 2005

[timscronin]

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

 

[mrdenny]

sp_change_users_login would be the command you are looking for.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com