-
using auto_fix option with sp_change_users_login
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|