October 4, 2006 at 8:30 am
Is there anyway to find out who/when dropped the tables in our databases? Thanks for any inputs
Minh Vu
October 4, 2006 at 11:37 am
Not unless you had a Profiler trace or some other auditing process running that was looking for that event.
Greg
Greg
October 4, 2006 at 1:16 pm
A log reader, such as Lumigent's Log Explorer, can show you what commands were run. But I don't believe it will show WHO ran the command.
Like Greg said, there's no way to tell after the fact if you haven't already been collecting the information.
-SQLBill
October 5, 2006 at 4:26 pm
Thanks for the inputs. Beside LogExplorer, there is no way to inform dba the object get dropped? All I need is to know the object get dropped so that I can rebuild it. I know this can happen no matter how good security we have, since the dba groups can accidently drop the tables as well and they're human beings.
Again, looking forward to hear from you since we are under the guns.
Thanks,
Minh Vu
October 6, 2006 at 5:19 am
It you wish to avoid accidental use of DROP table then use CREATE VIEW with SCHEMABINDING
This will generate error when drop statement is executed, so DBA can have a second chance. And to drop the table, first view has to be dropped, followed by drop table.
Cheers
deepak
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply