sp_extrapwdchecks is a 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. Use sp_addmessage to add error message for this failure in Adaptive Server.
