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 expire; you must reset your password at the first login.
By default, this value is turned off and this check is not applied to passwords.
To require a change of password at first login, enter:
sp_password policy 'set', 'expire login', [ 1 | 0 ]