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.
LOGINPROPERTY function by specifying the
select loginproperty('YourLoginName', 'DaysUntilExpiration');
Reference: BOL reference on LOGINPROPERTY