Action tracking

Hi,
We have a table that holds thousands of data in SQL server. However, the
data is suddently gone yesterday. I am just wondering if there is a way to
check when and how (who did) the data is gone. Can we track the action from
log files or somewhere?
Thanks in advance!
if you have the database at FULL recovery, download a trial version of Log
Explorer at lumigent.com. It will tell you who's who?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
> Hi,
> We have a table that holds thousands of data in SQL server. However, the
> data is suddently gone yesterday. I am just wondering if there is a way to
> check when and how (who did) the data is gone. Can we track the action
> from
> log files or somewhere?
> Thanks in advance!
|||Unfortunately, our database is Simple for recovery model. Is there any other
way to find it?
Thanks again!
"ME" wrote:

> if you have the database at FULL recovery, download a trial version of Log
> Explorer at lumigent.com. It will tell you who's who?
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:86B01DE6-8302-4C6D-9D63-8FFF7D24AB74@.microsoft.com...
>
>
|||:-(
why was it set at SIMPLE recovery if you need that much?
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:A7AD9D50-59E2-4B15-A03A-2399645BCC2E@.microsoft.com...[vbcol=seagreen]
> Unfortunately, our database is Simple for recovery model. Is there any
> other
> way to find it?
> Thanks again!
> "ME" wrote: