I am moving the backup files of several databases in a sql server to a
different physical box. I have a problem with matching the login id's in SQL
server with the usernames in the each database after the restore.
Can I use sp_change_users_login... When I use it I get the following error:
"Msg 15290, Level 16, State 1
Aborting this procedure. The Action 'AUTO_FIX' is incompatible with the other
parm values ('' , '')."
The bottom line is how do I match the sql login Id's(I recreate these in the
new box using the scripts) and the database usernames after I restore the
database backups in a different physical sql box.