password expiration specifies the number of days a password can exist before it expires. You specify this value on a global basis. Valid values include:
0 – the password will never expire.
1 through 32767 – the number of days the password can exist without expiring.
By default, this password complexity option is turned off and this check is not applied to passwords.
To specify the password expiration date, enter:
sp_passwordpolicy 'set', 'password expiration', number
