How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last week same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to allIn SQL Server 2005 you can use DDL Triggers. Using these triggers you can
record the time the object was deleted, the login and user name used to
delete the object and the command executed, among other things.
See BOL for more information.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>|||Hi
It sounds like you may need to review your security settings and who has
access to this system! If this is a development system then you should also
be keeping code in a version control system.
John
"retf" wrote:
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>