Tack database growth rate modifications Usually I use below query to get list of DBs which are with Percent growth or not having growth rate of 100 MB. I want to automate this process; How do I get alert when ever any developer change database growth rate value to any from our default configurations ?

SELECT DISTINCT
            db.name,
            growth,
            is_percent_growth
  FROM      sys.master_files mfile
            INNER JOIN sys.databases db ON mfile.database_id = db.database_id
  WHERE     ( growth &lt;&gt; 12800
              OR is_percent_growth = 1
            )
            AND db.state_desc = 'ONLINE'
            AND db.is_read_only = 0
            AND ( db.database_id &gt; 4
                  OR db.name = 'Model'
                )
  ORDER BY  name
Probably depends on how quickly you want to be alerted. 

If you just want to able to report on it then I'd probably suggest setting up a policy in Policy Based Management. You should be able to evaluate your instance on demand or on a schedule. You can generate an alert based off the SQL job it creates as well so you can be notified.

You could also look to just create a job that looked much like your query but either raise an error if there are databases that breach your policy (and append it to the alert)

The two options that would almost immediately let you know if someone had changed an autogrowth setting would be either via


DDL Server Scoped Trigger 
SQL Alert using WMI to query ALTER_DATABASE Events


However, the latter would probably need to use tokens and would definitely require Service Broker to be enabled on all databases to work.