Jeff,

Hint for restore: select * from sysmessages where...  There are a couple of IDs for Database and log restore: 18267, 18268 and also for file restore 18269

For tracking DDL I would use Profiler Trace with T-SQL Statement Completed Event and TextData filter on a particular statement and DatabaseID for a particular database. Do not overdo traces, files get big.

Noel, any suggestions for Alert on statements?

Yelena