Check mskb#q246133
>I am moving a number of db's to a new server. It is on the same domain. The DB users will need to be given logins on the new server, and I would like to minimize the labor with this. what is the best course?? Is there an automated way to map the DB users and give them logins on the new SQL server? I have looked at sp_change_users_login, but this seems to require an execution for each individual user, and I may need their passwords as well.
>
>Your help is this is greatly appreciated.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst