Home Forums SQL Server 2008 SQL Server 2008 - General Query to check when the SQL Server Service account password was last changed. RE: Query to check when the SQL Server Service account password was last changed.

  • June 16, 2014 at 1:13 pm

    #1722087

    If you are using a native SQL account, you can check in:

    sys.server_principals

    There is no date specifically for password changes, but the modify_date does get reset when the password is changed.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.