sp_extrapwdchecks is a new custom stored procedure that can contain user-defined logic for password complexity checks. You can configure sp_extrapwdchecks according to your security needs. Install sp_extrapwdchecks in the master database.
sp_extrapwdchecks caller_password, new_password, login_name
where:
caller_password specifies the current password.
new_password specifies the new password being set.
login_name specifies the login name associated with the password being changed or added.
sp_extrapasswordchecks must use raiserror to signal a failure to Adaptive Server. The error message for this failure should be added in Adaptive Server using sp_addmessage.
