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 all"retf" <re.tf@.terra.com.br> wrote in message
news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
> 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
>
Look at the schema change history report in Management Studio.
David|||Where I find this?
Thanks for the help.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
> "retf" <re.tf@.terra.com.br> wrote in message
> news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
>> 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
>
> Look at the schema change history report in Management Studio.
> David
>|||SS Management Studio, Summary Tab, Report, Schema Changes History.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:
> Where I find this?
> Thanks for the help.
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
> mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
> >
> > "retf" <re.tf@.terra.com.br> wrote in message
> > news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
> >> 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
> >>
> >
> >
> > Look at the schema change history report in Management Studio.
> >
> > David
> >
>
>|||Hi,
Thank you very much...:o) :o) :o) :o)
"Ben Nevarez" <bnevarez@.sjm.com> escreveu na mensagem
news:54A60353-0816-4335-839F-50D6682BFFB4@.microsoft.com...
> SS Management Studio, Summary Tab, Report, Schema Changes History.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "retf" wrote:
>> Where I find this?
>> Thanks for the help.
>> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
>> mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
>> >
>> > "retf" <re.tf@.terra.com.br> wrote in message
>> > news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
>> >> 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
>> >>
>> >
>> >
>> > Look at the schema change history report in Management Studio.
>> >
>> > David
>> >
>>