We use a tool called Log Explorer
(http://www.lumigent.com/products/le_sql/le_sql.htm) here on our
production machines. It essentially lets you view the log and see
exactly what operations occurred, and will script out an undo so you can
roll back specific operations. I think there is a 30 day demo.

-----Original Message-----
From: [Email Address Removed]
Sent: Sunday, November 23, 2003 8:53 PM
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