password exp warn interval indicates the number of days before a password expires that the password expiration warning messages displays. These messages display with every successful login until the password is changed or it expires. This value must be less than or equal to the password expiration.
Valid values are 0 – 365. This option is turned off by default.
To specify the password expiration warning interval, enter:
sp_passwordpolicy 'set', 'password exp warn interval', number
