How to find the date a login password was last changed in SQL Server 2008?
Use the PasswordLastSetTime option of the LOGINPROPERTY.
SELECT LOGINPROPERTY('YourLoginName', 'PasswordLastSetTime');
Use the PasswordLastSetTime option of the LOGINPROPERTY.
SELECT LOGINPROPERTY('YourLoginName', 'PasswordLastSetTime');