none
SQL Audit Settings - DB level vs Server Level RRS feed

Answers

All replies

  • If you enable this group in a server audit specification, it will track changes to database objects in all databases within that SQL Server instance

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Marked as answer by mg101 Monday, July 1, 2019 10:55 AM
    Monday, July 1, 2019 5:37 AM
  • Hi mg101,

     

    >>My question is, lets say, you use DATABASE_OBJECT_CHANGE_GROUP at the server level, it is my understanding that you would NOT need to also do a DB level audit with DATABASE_OBJECT_CHANGE_GROUP. The server level should pick up ALL db's info for this event.

     

    Yes,  you are right.  The audit log will record changes of all the database objects in this instance when you use DATABASE_OBJECT_CHANGE_GROUP at the server level.

     

    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

    Monday, July 1, 2019 7:43 AM
  • thanks Uri
    Monday, July 1, 2019 10:55 AM
  • Thx Dedmon
    Monday, July 1, 2019 10:55 AM