I need a script that will alert me via email if one of the following events occur:
1. A new database is created.
2. Recovery model not set to FULL.
3. There is no full backup for a database.
I would like this script to be dynamic if possible, and by that I mean that an email is sent the moment the recovery model is changed - is this possible or will I have to schedule it to run on a regular schedule?
Our SQL estate is a mixture of 2008R2 and 2005 but there is still one pesky box on 2000.