Wednesday, November 16, 2011

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'

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:

David said...

Thanks for that - easy, simple and useful :-)

Srinath said...

Thanks a lot...