check password for digit

This section provides information about check password for digit, a new configuration parameter.

Summary information

Name in pre-12.0 version

N/A

Default value

0

Range of values

1, 0

Status

Dynamic

Display level

10

Required role

System Security Officer

The System Security Officer can tell the server to check for at least one character or digit in a password using the server-wide configuration parameter check password for digit. If set, this parameter does not affect existing passwords. By default, checking for digits is off.

To activate check password for digit functionality, enter:

sp_configure "check password for digit", 1

To deactivate check password for digit functionality, enter:

sp_configure "check password for digit", 0