We help IT Professionals succeed at work.

user password retry

If the user typed the password twice or trice wrongly and hence locked out, how can the password be changed/overwritten using t-SQL Code? so he can login again,

thanks
Comment
Watch Question

Expert of the Quarter 2010
Expert of the Year 2010
Commented:
ALTER LOGIN [test] WITH password='test' unlock

A new password needs to be set at the same time

Author

Commented:
Thank you.