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