I am sorry if this sounds silly, but does this trigger actually prevent dropping of a table? Will it not just insert into the log table the details of the person who dropped it as opposed to preventing anyone from dropping it? Please clarify!!!

Thanks,
-Shyami