Find application password expiration date

Question

I changed password of my application on one sql server? when I am using Login property command I am getting last login date. I want to know when my application password is going to expired in SQL server. Please help me. Thank You all.

Answer 1

Use the LOGINPROPERTY function by specifying the DaysUntilExpiration property:

select loginproperty('YourLoginName', 'DaysUntilExpiration');

Reference: BOL reference on LOGINPROPERTY