There's no way you can tell what users have done unless you've setup some
form of auditing. If all your users are using NT Authentication, you could
check the Security Log (via event viewer) on the server and obtain a list of
users that had logged into the server at about the time you suspect the data
was deleted. You could then query these users and check what they were
doing.

Hope this is of some help...

Mohan

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Monday, November 24, 2003 9:14 AM
To: LazyDBA.com Discussion
Subject: RE: Data Missing


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]

---------------------------------------------------------------------
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] additional commands, e-mail: mssqldba-[Email Address Removed]
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.

**********************************************************************

MS Sql Server LazyDBA home page