Get Password Expiration Date in SQL Server 2008

SQL Server 2008 introduces a new argument called DaysUntilExpiration in the LOGINPROPERTY function, which returns the number of days until the password expires. You can use this property using the following code: SELECT LOGINPROPERTY('sa', 'DaysUntilExpiration')Note: If you get a null while executing the query, then either the login is not a valid login or your Operating System does not support