sp_cleanpwdchecks is a new custom stored procedure that allows you to define when and how to remove login and password-related attributes stored in user-defined tables. sp_cleanpwdchecks is user defined, and is dynamically called in the master database when you drop a login.
sp_cleanpwdchecks, login_name
where:
login_name – specifies the login name of the cleanup to be performed.
