data-konzept

'With the build-in function LOGINPROPERTY (http://msdn.microsoft.com/de-de/library/ms345412.aspx) you can queries information for a login like the last time the password has been change, how many days it take till the password expires, how often a bad password was entered or if the login is already locked.
With this Transact-SQL statement you can query this information for all SQL logins and calculate the date for password expiration e.g. to send a reminder email to change the password.

https://gallery.technet.microsoft.com/scriptcenter/When-will-a-SQL-login-d6fbb6df