"Create Database"notification only via ddl_trigger?
Hi all, Just a quick one: I want to set up a notification (alert ...whatever) for create database events. In a test environment I'm already using a ddl trigger, which sends an emial to me when a database is created. My question: are there any alternatives, smarter solutions? Regards Dirk
We does something with the CREATE_DATE in sys.database for a report we produce everyday. It simply reports on the DB/Tables/SP created in the previous day. Not real time though and may not be smarter, but works for us.