To expand, here's what I'd do:

Create table Logger

( myMessage nvarchar(max)

, DDLStatement nvarchar(max)

, UserName nvarchar(max)

, DatabaseName nvarchar(max)

, Timestamp datetime default (getdate())

)

;

Then I'd alter the trigger to insert data into there.

I'd then write a job that executed once an hour or so and if there was new data, email me.

The job/procedure would query the table

select ddlstatement

from logger

where timestamp > dateadd( hh, -1, getdate())