Hi Pete,

Here is a stored procedure that I use for notifying me on an existing database if any object is created, modified, etc.

Hope it helps and I understood your question correctly. Of course this USP needs to be part of the rest of object for notifications purposes.

(see attached)

And, thank you again Jonathan, I have been using this methodology database management, failed logins, autogrowth and DBuser Events..