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.
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
For details on the syntax and rules for using the new parameter, see sp_configure.
