Checking passwords for at least one digit

The system security officer can instruct the server to check for at least one 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.

This example activates the check password functionality:

sp_configure "check password for digit", 1

This deactivates the check password functionality:

sp_configure "check password for digit", 0

See sp_configure in Reference Manual: Procedures.