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
with
= new username,
,

So for mapping a user test with testlogi  we will use

ALTER USER test WITH login = testlogin

Leave a comment


Design a site like this with WordPress.com
Get started