none
Recommended auditing to track all changes within SQL Server user DB ? RRS feed

  • Question

  • Hello, what is the recommended method of tracking all activity & changes to a particular user DB and who did what and when?

    Including DMLs (Selects), DDLs, Creating/Dropping/Adjusting objects, Views, Stored Procs, Roles, Schemas, Users, etc...

    Thanks in advance.

    Monday, June 10, 2019 10:29 PM

All replies

  • Hi techresearch7777777,

     

    >>Hello, what is the recommended method of tracking all activity & changes to a particular user DB and who did what and when?

     

    I suggest you use sql server audit. It audits an instance of the SQL Server Database Engine or an individual database involves tracking and logging events that occur on the Database Engine. 

     

    SQL Server audit lets you create server audits, which can contain server audit specifications for server level events, and database audit specifications for database level events.

     

    For more details, please refer to SQL Server Audit Action Groups and Actions and How to set up and use SQL Server Audit

     

    Hope this could help you .

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, June 11, 2019 2:00 AM