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