CREATE TRIGGER [ddl_trig_database]
ON ALL SERVER
FOR DROP_DATABASE
AS
DECLARE @db VARCHAR(209)
SET @db = (SELECT 'Database Dropped: ' + EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','VARCHAR(229)'))
RAISERROR(@db, 16, 1)WITH LOG