Yes the account will get locked after that, i used to execute the following query to reset the password.

--LOGIN sa ENABLE

GO

ALTER LOGIN sa WITH PASSWORD = 'password'

GO

Thank You

Are you sure the password is changing and it's not that the account is being locked out?

Yes the account will get locked after that, i used to execute the following...

Yes this issue happens only for SA account, and i can able to see two sa accounts every time, even after deleting one of the SA account from SSMS--> Security...