SQL Server Object Changes

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.

To create the alert, create a Custom SQL - Multiple Numeric Return and make is look similar to this example: