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...
>
> 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...
>
>|||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...[vbcol=seagreen]
> SS Management Studio, Summary Tab, Report, Schema Changes History.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "retf" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment