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
specifies the current password.
specifies the new password being set.
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.
Do not use raiserror to get the expected
behaviour. raiserror updates the @@error global
variable. @@error is
also updated each time you execute a T-SQL statement, including print and if.
If raiserror is followed by any T-SQL statement, @@error gets
overwritten, and sp_extrapwdchecks fails
to return an error for a failed password if raiserror is
followed by any TSQL statement.
