DECLARE @EventData xml
SET @EventData = EVENTDATA()
 
--SELECT @EventData.value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),
--       @EventData.value('(/EVENT_INSTANCE/LoginName)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/UserName)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/SPID)[1]', 'int'),
--       @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(max)'),
--       @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/SchemaName)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'nvarchar(128)'),
--       @EventData.value('(/EVENT_INSTANCE/ObjectType)[1]', 'nvarchar(128)')
 
IF   ( @EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'nvarchar(128)') = 'YourDatabaseName'
   AND @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(128)') IN ( 'CREATE_TABLE', 'ALTER_TABLE', 'DROP_TABLE' )
   AND GETDATE() > '09/16/2009' )
BEGIN
     ROLLBACK
END