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

  • kmrmrp1703

    SSC Rookie

    Points: 32

    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: 148777

    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 Journeyman

    Points: 97

    Perhaps you are looking for change data capture?

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

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