Find who is changing advaced options in SQL 2008

  • we are keep getting following alert in SQL

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    I have enable the trace to see the but no luck,

    In my trace , I have enabled TextData,BatchStatrted,Batchended and couple of other columns as well.

    Appreciate your help

  • cmc123 (12/14/2016)


    we are keep getting following alert in SQL

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    I have enable the trace to see the but no luck,

    In my trace , I have enabled TextData,BatchStatrted,Batchended and couple of other columns as well.

    Appreciate your help

    It should be in the default trace if you want to check those files.

    Another option is that it should be in the Configuration Changes History report (it pulls form the trace files). In SSMS, Right click on the server, select Reports and select Configuration Changes History. User is included.

    Sue

  • This was removed by the editor as SPAM

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

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