When My SQL login Password Last Reset Iin 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