To Identify When was Password got Changed
security-audit #security-audit
SELECT name AS LoginName, modify_date AS LastPasswordChangeDate
FROM sys.sql_logins
WHERE name = 'YourLoginName' SELECT name AS LoginName, modify_date AS LastPasswordChangeDate
FROM sys.sql_logins
WHERE name = 'YourLoginName'