This alert will return a list of objects that have recently been modified. It uses the sys.objects table and the modify_date column for detection. This table is specific to each database, so it also loops through all non-system databases to get an instance-wide perspective.
Note: this alert will simply return the objects that were modified in some way. It will not return the details of the change like this custom alert will do:
To create the alert, create a Custom SQL - Multiple Numeric Return and make is look similar to this example:
