Who changed my sa password

  • Hi All,

    As you all know unfortunately SQL doesn’t have any tracking mechanism to know who changed the SA password.

    Is there any work around to track who have changed the sa password?

    Thanks a lot.

    --

    Thanks,

    DR

  • You could create something like a database with a table for tracking the information and put a DML trigger against the syslogins table in master that inserts a record into the tracking database everytime the account (or any account for that matter) is changed. You could also increase your auditing. I think C2 auditing would catch that information, but it basically gathers everything, so the audit files can grow rather quickly...

    Joie Andrew
    "Since 1982"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply