The following stored procedures have been modified for password complexity implementation:
sp_addlogin and sp_password – invoke the new password complexity checks.
sp_droplogin – If sp_cleanpwdchecks is present in the master database, it is executed after dropping a login with sp_droplogin.
sp_displaylogin – New sp_passwordpolicy security options are taken into consideration when displaying login information related to password expiration, maximum failed logins, and password length.
