Post reply

Audit Database Properties Changes

  • April 13, 2018 at 6:25 am

    #403257

    There is something weird going on with one of my servers. Seems like someone is changing the auto growth setting on my databases. Is there any way to audit this to see who is doing it

  • April 13, 2018 at 8:07 am

    #1986749

    keanyukas - Friday, April 13, 2018 6:25 AM

    There is something weird going on with one of my servers. Seems like someone is changing the auto growth setting on my databases. Is there any way to audit this to see who is doing it

    You can create a server side trace, capture event class SQL:BatchCompleted, column filter on TextData like 'Alter Database%'  to look for any changes to the database or or '%Modify file%, for just file property changes.

    Sue

  • April 13, 2018 at 8:18 am

    #1986752

    perfect thanks

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

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