expire login changes the login status to expired when a System Security Officer creates or resets a login. The login is then required to change the password on the first login. Valid values are:
0 – new or reset logins will not expire.
1 – new or reset logins do expire; reset your password at the first login.
By default, this value is turned off and this check is not applied to passwords.
To set the option to require a change of password at first login, enter:
sp_password policy 'set', 'expire login', [ 1 | 0 ]
