ObjectChange

[zikato]

There are many objects that are changed through stored procedures and don't show up in the object_altered extended event. Go through a list and add the exceptions:

SELECT 
    *
FROM sys.all_objects AS ao
WHERE 
    ao.type = 'P '
    AND ao.object_id < 0 
    AND 
    (
        ao.name LIKE '%update%'
        OR ao.name LIKE '%create%'
        OR ao.name LIKE '%delete%'
        OR ao.name LIKE '%drop%'
        OR ao.name LIKE '%enable%'
        OR ao.name LIKE '%disable%'
        OR ao.name LIKE '%configure%'
    )
ORDER BY ao.name