map login with users

When we restore backups to new server then users in the database are not mapped with their login in the new server
Its because sid is not matching.In this case we will are used to with sp_change_users_login
But this procedure will be deprectated in future version . So instead of this we should use alter user

alter user username
= new username,

So for mapping a user test with testlogi  we will use

ALTER USER test WITH login = testlogin

No comments:

Post a Comment

Popular Posts