SQL Server - Alert for when an object gets created, modified or dropped

Within SQL Server, it is nice to know when objects are getting created, modified and or dropped. To configure DPA to alert you about these events, here are the steps:

Step 1 - Either edit an existing extended event session like system_heath or create a new session and have it watch for events named object_created, object_altered, object_deleted. On some versions, these are already part of the system_health extended event session, so check there first.

Step 2 - Configure a DPA alert to read this data (Alerts > Manage Alerts > Custom - Custom SQL Alert - Multiple Numeric Alert). 

SQL Statement is shown in the attached script.

Anonymous