min lower char in password sets the minimum number of lowercase letters for a password. Valid values are:
0 through 16 – indicates the number of lowercase letters required for a password.
-1 – indicates that the password cannot contain lowercase characters.
By default, this password complexity option is turned off and this check is not applied to passwords.
To set the minimum number of lowercase letters in a password, enter:
sp_passwordpolicy 'set', 'min lower char in password', number
For example, if you set min lower char in password to
3, you can create a login johnd with
the password abcdEF1#,
by entering:
sp_addlogin 'johnd', 'abcdEF1#'
However, if you attempt to add the following login:
sp_addlogin 'johnd', 'abCDE#1'
and the minimum number of lowercase letters allowed is 3, the command fails.
