Msg 15600, Level 15, State 1, Procedure sp_change_users_login, Line 214
An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.
I ran this script:
EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login'
Fix:
I added @Password parameter:
EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login', @Password = 'password'
2 comments:
Thanks for that - easy, simple and useful :-)
Thanks a lot...
Post a Comment