When My SQL login Password Last Reset in SQL Server

So now with this command its easy to see when sa password is last reset. But this only works with SQL user not for windows user.

Syntax: SELECT LOGINPROPERTY('SQL user', 'PasswordLastSetTime');
Example: SELECT LOGINPROPERTY('sa', 'PasswordLastSetTime');

--Note: This will only return detail for SQL user not windows user

No comments:

Post a Comment