Hi Aadhar,

I am not sure if thers is any way to monitor the execution of sp_configure procedure.

You can use the below approach.

1. Make sure "show advanced options" is always set to 1.

2. Create a table tbl_spconfigure to hold the sp_configure values.

3. Use a procedure to compare the current values to the stored values.

3.1. Create a temp_spconfigure table and populate it with the current sp_configure values.

3.2. Delete from the temp_spconfigure table the values that match the tbl_spconfigure values.

3.3. Populate a tracking_spconfigure table with the old values (tbl_spconfigure) and the new values(temp_spconfigure table) for the values that exist in the temp_spconfigure table.

3.4. Create a trigger on the tracking_spconfigure table to send you an email before/after populating.

4. Truncate tbl_spconfigure and re-populate with the current values.

5. Schedule a SQL Agent job to execute the procedure at a specified freequency (every minute may be).

Hope this helps.

Cheers,

Mohammed Imran Ali.