thanks for the feedback! they both worked great!

i'm trying to do the exact same thing on this... any additional info on how

to set this up would be G R E A T L Y appreciated!

thanks

ok... great. that gives me a starting point.

appreciate the feedback.

cool. DDL Triggers are really handy.

i'm putting together all kinds of automation now.

thanks again for the reply...

i've got jobs that run basic reports for each database size, mods, etc

and would like to have those jobs dropped if the database was dropped

so figure...

so if i wanted to create a trigger... i couldn't do it on the new table correct?

sys.databases

i simply get an error about invalid object.

how do i reference it?

phew... 🙂

maintenance plan... what a time saver.

thanks!