Audit

• vijay.singh 14112

  SSCommitted

  Points: 1589

  More actions

  December 2, 2015 at 11:56 pm

  #322723

  Hi All,

  How can we track security changes in SQL server 2012?

  For example: Someone disabled Login.

  Details required: Who disabled.

  Thanks in advance.

  Regards,

  Vijay

• FridayNightGiant

  SSCertifiable

  Points: 7151

  More actions

  December 3, 2015 at 1:13 am

  #1843702

  Check out Audits and Server Audit Specifications. If I remember correctly the SERVER_PRINCIPAL_CHANGE_GROUP will track changes to logins.