How can we track & record SQL user activity on the database

• kmrmrp1703

  Valued Member

  Points: 62

  More actions

  October 16, 2020 at 5:43 am

  #3797864

  Dear Sir,

  I am beginner in the MSSQL server 2012 administration Anyone can help me to track & record sql user activity on the particular database for audit purpose.

  Abhishek

   

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 16, 2020 at 10:08 am

  #3797921

  Check this out.  Since you're on SQL Server 2012, what you can audit may be restricted if you don't have Enterprise Edition.

  John

• Cebisa

  SSC Enthusiast

  Points: 151

  More actions

  October 19, 2020 at 12:55 pm

  #3798806

  Perhaps you are looking for change data capture?