You can't know unless you monitor it. You have to setup auditing beofre
problems happen. Have a look in SQL server log in case, but it'll not give
you any hint of who did what with the content of tables.

> -----Original Message-----
> From: [Email Address Removed]
> [mailto:[Email Address Removed]
> Sent: lundi, 24. novembre 2003 03:53
> To: LazyDBA.com Discussion
> Subject: Data Missing
>
>
> Hi,
>
> Pls.help as this is a Critical Issue,
> Some Data was Missing inside Our Production Server This
> Morning. Before
> Re-Storing a Backup i want to know the List of Users Who has
> done Database Operations (What Operations on Which Tables) on
> Our production Server.
>
> Is it possible to find out..if so please help....
>
> u'r help will be very much appreciated.
>
> Thanks in Advance.
>
> Regards,
> Chava Sreedhar
> Singapore
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com To unsubscribe,
> e-mail: mssqldba-[Email Address Removed] For additional
> commands, e-mail: mssqldba-[Email Address Removed]
MS Sql Server LazyDBA home page