Find application password expiration date 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.
Use the LOGINPROPERTY function by specifying the DaysUntilExpiration property:

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


Reference: BOL reference on LOGINPROPERTY