sp_cleanpwdchecks is a 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, login_name
specifies the login name of the cleanup to be performed.
sp_cleanpwdchecks is user-defined, and is dynamically called in the master database when you drop a login.
