I have been trying to use the auto_fix option with the sp_change_users_login proc but must be doing something wrong. My understanding is that the autofix option will do a best guess to fix logins for a database which was moved.
When I type "sp_change_users_login auto_fix" I get an error, or if I use
"sp_change_users_login @action = auto_fix" I still get an error . The example in BOL isn't very clear. If all I want is the system to best guess a fix what is the proper syntax?
Thanks